CV95: DB2 10 for z/OS System Performance Analysis and Tuning


Code: CV95
Duration: 4 days


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


After completing this course, you should be able to:

  • 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 outcomes 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 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 (CV83) or have equivalent experience
  • DB2 10 for z/OS Database Administration Workshop Part 2 (CV84) or have equivalent experience
  • DB2 10 for z/OS System Administration (CV85) or equivalent experience
  • DB2 10 for z/OS Utilities for Database Administrators (CV87) or have equivalent experience


Classroom and hands on lab exercises.

Course Schedule »