DB2 Data Sharing Performance Tuning Course

Description

The course provides a technical introduction to the main concepts of DB2 UDB for z/OS Version 7 and Version 8 Data Sharing. It then looks in detail at performance monitoring and tuning in a DB2 Data Sharing environment. This is an advanced course suitable for DBAs, systems programmers, operations personnel, and anyone involved with DB2 Data Sharing performance. Students should have attended the DB2 System Performance Tuning course or have an equivalent level of knowledge. The course includes demonstrations using any available on-line DB2 performance monitor and a paper workshop.

Duration

2 days

Course Outline

1  Overview
 - Parallel Sysplex.
 - DB2 Data Sharing.
 - CFRM Policy
 - Protecting Data Consistency.
 - Group Buffer Pools.
 - Global Locking.

2  Performance Issues
 - Performance Objectives.
 - Costs of Data Sharing.
 - CPU Costs.
 - CF Links.
 - Sizing CF Structures.
 - CF v ICF.

3  Operation & Monitoring
 - DB2 Commands.
 - MVS XCF Commands.
 - Retained Locks.
 - DB2 Traces.
 - RMF Reports.

4  Group Buffer Pool Processing
 - Group Buffer Pool Processing.
 - Pageset P-Locks.
 - Page Registration.
 - Directory Reclaims.
 - GBP Writes.
 - Page P-Locks.
 - Castout.
 - GBP Duplexing.

5  Group Buffer Pool Tuning
 - Controlling GBPs.
 - Initial Sizing of the GBPs.
 - Group Buffer Pool Tuning.
 - Reducing Inter-DB2 R/W Interest.
 - Monitoring Group Buffer Pools.
 - GBP Tuning Recommendations.
 - Monitoring Using Commands.

6  Lock Structure Tuning
 - Global Lock Structure.
 - Lock Processing.
 - False, XES, and Real Contention.
 - Lock Structure Duplexing.
 - Initial Sizing of LOCK1.
 - Lock Structure Tuning.
 - Lock Avoidance.
 - Monitoring Global Locking.

7  SCA Tuning

8  Application Issues
 - Controlling GBP Caching.
 - Reducing Page P-Locks.
 - Reducing Pageset L-Lock Activity.
 - Reducing L-Lock Propagation.
 - Sysplex Query Parallelism.
 - DB2 Accounting Trace.

9  RMF Monitoring