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