About this Course

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

Audience Profile

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.

At Course Completion

Upon completing this course, students will 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
• 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

Prerequisites

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

Course Outline

1. DB2 system performance analysis and tuning introduction

2. The DB2 trace

3. Introduction to the operating system and hardware

4. Service time, queuing time, Case A transaction analysis

5. Introduction and analysis of case E

6. The DB2 attachments

7. In-depth application of the DB2 system

8. The disk subsystem and DB2 I/O

9. Capacity analysis and massive Batch