SUMMARY:   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:   3 Days. 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. MT/04