(David Norfolk) There is suddenly new interest in monitoring Java on mainframes – I’m not talking about running lots of Java VMs on Linux but about running Java against big mainframe systems on z/OS. This might be about modernising legacy COBOL applications (Java skills are easier to find than COBOL
Tag: IBM
DB2 for z/OS: Indexes and Foreign Keys
(Robert Catterall) The functionality of DB2 for z/OS is enhanced, in ways small and big, on a regular basis. There’s plenty to keep up with, and it is understandable that some product improvements could fly under the radar of a database administrator and escape notice. I encountered this situation a
An Introduction to IBM i’s Row and Column Access Control (RCAC)
(Carol Woodbury) Row and Column Access Control (RCAC) was introduced in V7R2 and brings the security implementation more in line with other DB2 implementations, providing administrators a way to filter what information is available without having to develop and manage logical files.
Best Practices for Tuning Local and Group Bufferpools
(Troy L Coleman) During May’s IDUG NA conference, I attended a session by IBM’s John Campbell. A question came up on how to size and configure local and group bufferpools. John mentioned that a presentation he’d given on this in 2013 is available as a webcast.
The DB2Night Show #Z71: DB2 12 Preview
(Martin) 98% of our studio audience learned something!Jeff provided a concise, clear overview of the new features in DB2 12 for z/OS.
IBM PureData System for Analytics: Improving Query Performance by Tuning Netezza Optimizer Through Postgres Configuration
(Sanjit Chakraborty) The IBM PureData System for Analytics, powered by Netezza® technology (“IBM Netezza”), is a data warehouse appliance that features a purpose-built analytics engine. Netezza generates a query plan for all queries that run on the system.
IBM Q Replication: Frank’s Field Notes, Summer ‘16
(Kim May) Please join us Thursday, July 28th, from 11am-12pm EDT for a free webinar with an update on IBM’s Q Replication.
Dropped object recovery: A DBA’s nightmare
(Paul Pendle) Relational database management systems (RDBMS) maintain logical relationships between components. These logical relationships create dependencies that are analogous to parent-child relationships.
The DB2Night Show #182: DB2 LUW V11.1 Upgrade Best Practices and Tips!
(Scott) 100% of our audience learned something! No surprises there! Everyone learns from Melanie! For our season #7 grand finale, Melanie gave our audience the complete scoop on upgrading to DB2 LUW V11.1!
The DB2Night Show #181: DB2 LUW Advanced Performance Diagnostics for SQL
(Scott) 100% of our audience learned something! David gave us another great IDUG presentation packed with tips and advice for monitoring and diagnosing performance issues in DB2 LUW.