DB2 System Performance Tuning Course

Description

The course provides detailed coverage of System Performance Tuning for DB2 UDB for z/OS Version 8. It is intended for DBAs and systems programmers. A good working knowledge of DB2 is a prerequisite. The course includes demonstrations using any available on-line DB2 performance monitor.

Duration

4 days

Course Outline

1 Introduction
 - What is Performance?
 - Performance Factors.
 - Performance Objectives.

2 DB2 Architecture
 - DB2 Address Spaces.
 - RDS, DM and BM.
 - Connections and Threads.
 - Serialisation Mechanisms.
 - Resource Accounting.

3 System Resource Factors
 - Virtual Storage Layout.
 - CSA, SSAS, and IRLM Storage.
 - DBAS Storage.
 - DB2 System Parameters.
 - Allied Address Spaces.
 - DB2 and MVS Workload Manager.

4 Monitoring & Reporting
 - DB2 Instrumentation Facility.
 - Statistics, Accounting, and Performance Traces.
 - DB2PE Statistics Report.
 - Monitoring DBM1 Storage.

5 Buffer Pool Processes
 - Buffer Pool Basics.
 - Getpage Processing.
 - Sequential, Dynamic, and List Prefetch.
 - Parallelism.
 - DB2 Sort.
 - Buffer Pool Thresholds.

6 Monitoring & Tuning the Buffer Pools
 - Buffer Pool Assignments.
 - Buffer Pool Settings.
 - Prefetch and Parallelism.
 - Monitoring and Tuning the Buffer Pools.

7 The EDM Pools
 - EDM Pool and DBD Cache.
 - Dynamic Statement Caching.
 - EDM Pools Monitoring and Tuning.

8 Log Buffers
 - Commit Processing.
 - Forward Recovery and Rollback.
 - Active Log, Archive Log, and BSDS.
 - Checkpoints.
 - Fast Log Apply.
 - Monitoring and Tuning DB2 Logging.

9 Transaction Locking
 - Lock Size, Mode, and Duration.
 - Tablespace Locks.
 - Page and Row Locks.
 - Lock Avoidance.
 - Page Latching, C_LSN, and PUNC.
 - IRLM.
 - Locking Parameters.
 - LOB Locking.
 - Monitoring and Tuning Locking.

10 Other Serialisation Mechanisms
 - Partition Independence.
 - Claim and Drain.
 - Restrictive States.
 - Monitoring Claim and Drain.

11 DB2 Attachments
 - The TSO, CICS, IMS, and Call Attaches.
 - Two Phase Commit.
 - Monitoring and Tuning the Attaches.

12 DDF, SPs, and UDFs

13 Utilities and Special Processes
 - Utility Performance Factors.
 - Utility Serialisation.
 - Load, Reorg, Copy, Recover, and Runstats.
 - Monitoring Utilities.
 - DB2 Catalog and Directory.

14 Other I/O Issues
 - Dataset Placement and Cache.
 - Pageset Open and Close.