DB2 Data Sharing Implementation
Course: DB2DSI
Duration: 3 Days
Level: I
On our website at:
http://www.verhoef-training.com/courses/DB2DSI.html
Course 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.
Topics Covered In This Course
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.
Related Courses
Code |
Course Title |
Duration |
Level |
|
DB2A |
DB2 for z/OS Administration |
5 Days |
I |
Details |
DB2UDBI |
DB2 for LUW (Linux, UNIX, Windows) |
2 Days |
I |
Details |
DB2DR |
DB2 Application Data Recovery |
3 Days |
I |
Details |
DB2M |
Advanced DB2 Application Programming |
3 Days |
II |
Details |
DB2M9 |
DB2 UDB/390 Version 9 Transition |
2 Days |
II |
Details |
Every student attending a Verhoef Training class will receive
a certificate good for $100 toward their next public class taken
within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a
single student in any of our public or web-based classes.
Contact your account manager or our sales office for details.