Home About Courses Schedule Services Webinars Contact Search

Db2 for z/OS Data Sharing Essentials


Duration: 4 Days

Method: Instructor led, Hands-on workshops

Price: $2450.00

Course Code: DB5020


This course is intended for Db2 professionals, system programmers, system administrators and DBAs, as well as other z/OS support personnel responsible for the implementation and support of a Db2 data sharing environment .


This four day course is designed to teach Db2 Professionals the components of Db2 for z/OS data sharing; the implementation and support of a Db2 data sharing environment; and the operational and recovery considerations when working in a Data Sharing environment.


Upon successful completion of this course, the student will be able to:

  • Describe the major components of Db2 for z/OS data sharing
  • Understand the planning considerations for data sharing
  • Describe the detailed mechanics of Db2 for z/OS data sharing
  • Understand the unique installation requirements of data sharing
  • Describe the Db2 operational considerations for a data sharing group
  • Display a working knowledge of the syntax and usage of data sharing commands
  • Understand performance considerations unique to a data sharing environment
  • Describe how Db2 recovery processes are different in a data sharing environment versus a standalone Db2 environment
  • Describe the failure analysis procedures unique to a data sharing environment


Participants should be thoroughly familiar with the Db2 for z/OS mainframe environment preferably with production experience with Db2 for z/OS.


  • I. z/OS Sysplex Overview
    • Why Parallel Sysplex?
    • Products in a Sysplex
    • XES (Cross-System Extended Services)
    • XCF (Cross-System Coupling Facility)
    • Sysplex Commands
    • Data Sharing Overview
  • II. Db2 Data Sharing Mechanics
    • Single System Image
    • Data Sharing Groups
    • BSDS and Logs
    • Work File Databases
    • CF Structures
      • Shared Communications Area
      • Group Buffer Pools
      • Inter-Db2 Read-Write Interest
      • Data Consistency
      • Castout Processing
      • Global Locking
  • III. Db2 Data Sharing Planning
    • Prerequisites
    • Connectivity
    • Naming Conventions
    • Availability
    • Coupling Facility Structure Size Estimates
    • Sample CF Policy Definitions
    • Db2 Storage Estimates
    • Security and Authorization
    • Where to Start
  • IV. Installation and Migration
    • Installation CLISTs
    • Installing a Data Sharing Group
    • Enabling Data Sharing
    • Adding Members
    • Subsystem Startup Parms unique to Data Sharing
    • Disabling and Re-enabling Data Sharing
    • Communications with a Data Sharing Group
  • V. Data Sharing Environment Operations
    • Normal Db2 Operations
    • Db2 Startup and Shutdown Procedures
      • Phases of Startup
      • Starting Members
      • Group Restart
    • Db2 Commands
    • Command Scope
    • Non-Db2 Commands
    • Submitting Work to be Processed
  • VI. Database and Application Performance Considerations
    • Getting Ready for Data Sharing
    • Local Buffer Pools
    • Database Objects Review
    • Locking and Concurrency
    • Application Review
    • Best Practices
  • VII. Subsystem & CF Performance Considerations
    • Key Performance Factors
    • Coupling Facility Factors
    • Monitor & Tune Db2
    • RMF CF Reports
    • Db2 Traces
    • Tuning Approach
    • Best Practices
  • VIII. Db2 Data Sharing Recovery Environment
    • Logging Environment
    • Catalog & Directory
    • Utilities
    • Logical Page List
    • LPL and GRECP Recovery
    • Establishing Quiesce Point
    • Failure Analysis
  • IX. Db2 Non-Sysplex Failure Recovery
    • Member Failures
    • Catalog and Directory Failures
    • Application Failures
    • Attachment Failures
    • Short on Storage
      • SCA
      • Lock Structures
      • Group Buffer Pools
  • X. Db2 Sysplex Failure Recovery
    • CPC Failures
    • Structure Failures
    • CF Out of Space conditions
    • Reallocating Structures
    • Timer Failures
    • Connectivity Failures
    • Disaster Recovery Considerations