DB2 Data Sharing Implementation

Course:  DB2DSI
Duration:  3 Days
Level:  I
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.

« Hide The Details
Topics Covered In This Course


  • 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.
  • Sysplex Query Parallelism.
  • DB2 Accounting Trace.
« Hide The Details
Related Courses
Code Course Title Duration Level
DB2 for z/OS Administration
5 Days
DB2 for LUW (Linux, UNIX, Windows)
2 Days
DB2 Application Data Recovery
3 Days
Advanced DB2 Application Programming
3 Days
DB2 UDB/390 Version 9 Transition
2 Days

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.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]