DB2 Data Sharing Implementation Course

Description

The course provides detailed technical coverage of DB2 for z/OS and OS/390 Data Sharing. It covers the main technical issues that need to be addressed when implementing Data Sharing. The course covers DB2 Version 7 and Version 8.

This is an advanced course suitable for DBAs, systems programmers, and operations personnel who are involved in planning for and implementing DB2 Data Sharing. Students should have a good knowledge of DB2 in a non-Data Sharing environment and of z/OS or OS/390.

Duration

2 days

Course Outline

1  Overview
 - Parallel Sysplex.
 - DB2 Data Sharing.
 - Protecting Data Consistency.

2  Planning For Data Sharing
 - Reasons for Using Data Sharing.
 - Hardware and Software Prerequisites.
 - Costs of Data Sharing.
 - Naming Standards.
 - Availability Issues.
 - CFRM Policy.
 - Sizing CF Structures.
 - Sizing Datasets.

3  Protecting Data Consistency
 - Group Buffer Pools.
 - Group Buffer Pool Processing.
 - Castout.
 - Controlling GBPs.
 - Global Locking.
 - L-Locks and P-Locks.
 - Lock Processing.
 - False, XES, and Real Contention.
 - Pageset P-Lock Negotiation.

4  Implementing Data Sharing
 - Enabling Data Sharing.
 - Adding Another Member.
 - Disabling Data Sharing.
 - Re-Enabling.

5  Connecting to a Data Sharing Group
 - Local Connection.
 - Remote Connection.

6  Recovery Issues
 - Application Data Recovery.
 - CF Structure Failures.
 - DB2 Member Failure.
 - Disaster Recovery.

7  Operation & Monitoring
 - Console Messages.
 - DB2 Commands.
 - MVS XCF Commands.
 - Retained Locks.

8  System Performance Issues
 - CF Size and Links.
 - Lock Structure Tuning.
 - Reducing Inter-DB2 RW Interest.
 - Lock Avoidance.
 - Monitoring Global Locking.
 - Group Buffer Pool Tuning.
 - SCA Tuning.
 - DB2 Statistics Trace.
 - RMF Reports.
 - Auto Alter.

9  Application Performance Issues
 - GBPCACHE Option.
 - Space Map Considerations.
 - LOCKPART.
 - Sysplex Query Parallelism.
 - DB2 Accounting Trace.