Overview
This course explains how to monitor and tune DB2 10 for z/OS from a system point of view.
Public
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.
Prerequisits
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
Objective
- 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
Topics
- 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
