The course provides a technical introduction to the main concepts of DB2 for z/OS Data Sharing. It looks at the reasons why sites implement Data Sharing and the costs involved. It also covers the main technical issues that need to be addressed when implementing Data Sharing. The course is suitable for technical management, DBAs, systems programmers, operations personnel, and anyone involved in the decision on, or planning for, DB2 Data Sharing. Students should have a working knowledge of DB2 in a non-Data Sharing environment and of z/OS.
1 day
1 Overview - 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. - CFRM Policy. 3 Protecting Data Consistency - Group Buffer Pools. - Global Locking. - Sample Configuration. 4 Recovery Issues - Application Data Recovery. - CF Structure Failures. - DB2 Member Failure. - MVS Failure. - Disaster Recovery. 5 Performance Issues - CF Size and Links. - Lock Structure Tuning. - Reducing Inter-DB2 RW Interest. - Lock Avoidance. - Lock Structure Size. - Group Buffer Pool Tuning. - SCA Tuning. 6 Operation and Monitoring - Console Messages. - DB2 Commands. - MVS XCF Commands. - Retained Locks. - DB2 Traces. - RMF Reports.