Verhoef Training USA

Training Courses and On-Line Classes Preferred By IT Pros

Visit us at:   http://www.verhoef-training.com

103 Hillside Ave., PO Box 1515
West Caldwell, NJ 07006
Main Office:  800.631.0410
Sales Office:  800.533.3893

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.