DB2 System and Data Sharing Performance Course

Description

The course provides detailed coverage of System Performance Tuning, including Data Sharing, 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 and workshops.

Duration

5 days

Course Outline

1  Introduction

2  DB2 Architecture

3  System Resource Factors
 - Virtual Storage Layout.
 - DB2 System Parameters.
 - DB2 and MVS Workload Manager.

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

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
 - Active Log, Archive Log, and BSDS.
 - 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.
 - LOB Locking.
 - Monitoring and Tuning Locking.

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

11 DB2 Attachments

12 DDF, SPs, and UDFs

13 Utilities and Special Processes

14 Other I/O Issues

15 Data Sharing Performance Issues
 - Costs of Data Sharing.

16 Group Buffer Pool Processing
 - Group Buffer Pool Processing.
 - Page Registration.
 - Directory Reclaims.
 - GBP Writes.
 - Castout.

17 Group Buffer Pool Tuning
 - Controlling GBPs.
 - Monitoring Group Buffer Pools.
 - GBP Tuning Recommendations.

18 Global Lock Structure Tuning
 - Lock Processing.
 - False, XES, and Real Contention.
 - Lock Structure Tuning.
 - Monitoring Global Locking.

19 SCA Tuning

20 Data Sharing Application Issues
 - Controlling GBP Caching.
 - Reducing Lock Activity.
 - Sysplex Query Parallelism.