Articles & Content


DB2 for z/OS V9 and V10 Enhancements for System Programmers (A04)

Topic: 2010 EMEA

Subtopic: DB2 for z/OS

DATE: 2010-11-9 (08:30 - 09:30)
SPEAKERS: John Campbell (IBM DB2 for z/OS Development), John Tobler (IBM DB2 for z/OS Development)

DB2 for z/OS V9 and V10 provide a wealth of enhancements targeted toward aiding system programmers. DB2 has been improved with self-healing mechanisms and enhanced serviceability features. These include but are not limited to IFC thread monitoring and accounting improvements, IFC storage monitoring, virtual storage constraint identification and diagnosis, serviceability command enhancements, CPU stall monitoring, logging related enhancements, and new buffer pool options. This presentation will give an overview of these features, and also give some best practices for increasing the health of your DB2 systems. Awareness and exploitation of these features and practices can increase availability levels and reduce the total cost of ownership for DB2 for z/OS.

EXP. LEVEL: Intermediate,Advanced


Understand the usage of the -DISPLAY THREAD SERVICE command

Be able to leverage the internal monitor

Understand the use of IFCID225 and 217 be able to identify critical virtual and real storage values

Understand the options DB2 provides to deal with large SMF volumes and the tradeoffs inherent in these options

Understand what changes are being made in the DB2 logger and buffer manager to maintain system performance over varied workloads and the steps needed for full exploitation

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.