AUDIENCE:   This is an advanced course suitable for DBAs, systems programmers, and operations personnel who are involved in planning for and implementing DB2 Data Sharing. PREREQUISITES:   A good knowledge of DB2 in a non-Data Sharing environment and of z/OS systems is required. DURATION:   2 days. Hands on. OBJECTIVES:   The course provides detailed technical coverage of DB2 UDB for z/OS Data Sharing. It covers the main technical issues that need to be addressed when implementing Data Sharing. COURSE CONTENT:   Overview - Parallel Sysplex. - DB2 Data Sharing. - Protecting Data Consistency. 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. 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. Implementing Data Sharing - Enabling Data Sharing. - Adding Another Member. - Disabling Data Sharing. - Re-Enabling. Connecting to a Data Sharing Group - Local Connection. - Remote Connection. Recovery Issues - Application Data Recovery. - CF Structure Failures. - DB2 Member Failure. - Disaster Recovery. Operation & Monitoring - Console Messages. - DB2 Commands. - MVS XCF Commands. - Retained Locks. 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. - CFMON. - Auto Alter. Application Performance Issues - GBPCACHE Option. - Space Map Considerations. - LOCKPART. - Sysplex Query Parallelism. - DB2 Accounting Trace.