Verhoef Training

11 Kingsmead Square, Bath, BA1 2AB.
Tel: 01225 339705 Fax: 01225 339671




DB2 UDB for z/OS Data Sharing Overview




AUDIENCE:   Technical management, DBAs, systems programmers, operations personnel, and anyone involved in the decision on, or planning for, DB2 Data Sharing.

PREREQUISITES:   A working knowledge of DB2 in a non-Data Sharing environment and knowledge of z/OS systems.

DURATION:   1 day.

OBJECTIVES:   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.

COURSE CONTENT:  

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

Planning For Data Sharing
- Reasons For Using Data Sharing.
- Costs of Data Sharing.
- Hardware & Software Prerequisites.
- Naming Standards.
- CFRM Policy.

Protecting Data Consistency
- Group Buffer Pools.
- Global Locking.
- Sample Configuration.

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

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.

Operation & Monitoring
- Console Messages.
- DB2 Commands.
- MVS XCF Commands.
- Retained Locks.
- DB2 Traces.
- RMF Reports.
- CFMON.

© 2007 Verhoef Training, Ltd.