This course explains how to monitor and tune DB2 10 for z/OS from a system point of view.

• Describe DB2 processes as they relate to DB2 performance
• Interpret DB2 Trace Output
• Understand the steps needed to analyze and tune a DB2 subsystem
• Provide good input to system programmers to allow them to effectively tune the z/OS system for best DB2 performance

These objectives are met by discussing how to:

• Monitor and control the DB2 workload
• Monitor and tune IMS/CICS/DDF performance
• Monitor and tune DB2 buffer pools, EDM pool,logging and IRLM execution
• Tune DB2 attachments, including the DB2 side of distributed requests
• Analyze bottlenecks
• Communicate with systems people about DB2-related issues
• Communicate with application developers on DB2 performance topics
• Interpret DB2 statistics and accounting traces
• Establish guidelines which enhance DB2 system performance
• Understand how DB2 works well enough to be able to react effectively to various situations

This advanced course explains how to monitor and tune DB2 10 for z/OS from a system point of view. This course is suitable for DB2 system tuners, Enterprise capacity planners and System programmers.

You should complete:

• DB2 10 for z/OS Database Administration Workshop Part 1 (CV831) / DB2 10 for z/OS Database Administration Workshop Part 1 (ILO) (3V831), or have equivalent experience
• DB2 10 for z/OS Database Administration Workshop Part 2 (CV842) / DB2 10 for z/OS Database Administration Workshop Part 2 (ILO) (3V842), or have equivalent experience
• DB2 10 for z/OS System Administration (CV851) / DB2 10 for z/OS System Administration - ILO (3V851), or equivalent experience
• DB2 10 for z/OS Utilities for Database Administrators (CV871) / DB2 10 for z/OS Utilities for Database Administrators (ILO) (3V871), or have equivalent experience

• DB2 system performance analysis and tuning introduction
• The DB2 trace
• Introduction to the operating system and hardware
• Service time, queuing time, Case A transaction analysis
• Introduction and analysis of case E
• The DB2 attachments
• In-depth application of the DB2 system
• The disk subsystem and DB2 I/O
• Capacity analysis and massive Batch

Prior to enrolling, IBM Employees must follow their Division/Department processes to obtain approval to attend this public training class. Failure to follow Division/Department approval processes may result in the IBM Employee being personally responsible for the class charges.

GBS practitioners that use the EViTA system for requesting external training should use that same process for this course. Go to the EViTA site to start this process:http://w3.ibm.com/services/gbs/evita/BCSVTEnrl.nsf

Once you enroll in a GTP class, you will receive a confirmation letter that should show:

• The current GTP list price
• The 20% discounted price available to IBMers. This is the price you will be invoiced for the class.