DB2 for z/OS Data Sharing Essentials (DB5020)

Request a Quote for this class

About this Course

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.

Audience Profile

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 .

At Course Completion

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.

Course Outline

1. 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

2. DB2 Data Sharing Mechanics

  • Single System Image
  • Data Sharing Groups
  • BSDS and Logs
  • Work Files Database
  • CF Structures
    • Shared Communications
    • Group Buffer Pools
    • Inter-DB2 Read-Write Interest
    • Data Consistency
    • Castout Processing
    • Global Locking

3. DB2 Data Sharing Planning

  • Prerequisites
  • Connectivity
  • Naming Conventions
  • Availability
  • Coupling Facility Structure Size Estimates
  • Sample CF Policy Definitions
  • DB2 Storages Estimates
  • Security and Authorization
  • Where to Start

4. Installation and Migration

  • Installation CLISTs
  • Installing a Data Sharing Group
  • Enabling Data Sharing
  • Adding Members
  • Subsystem Startup Parms unique to Data Sharing
  • Communications with a Data Sharing Group

5. 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

6. Database and Application Performance Considerations

  • Getting Ready for Data Sharing
  • Local Buffer Pools
  • Databases Objects Review
  • Locking and Concurrency
  • Application Review
  • Best Practices

7. Subsystem & CF Performance Considerations

  • Key Performance Factors
  • Coupling Facility Factors
  • Monitor & Tune DB2
  • RMF CF Reports
  • DB2 Traces
  • Tuning Approach
  • Best Practices

8. DB2 Data Sharing Recovery Environment

  • Logging Environment
  • Catalog & Directory
  • Utilities
  • Logical Page List
  • LPL and GRECP Recovery
  • Establishing Quiesce Point
  • Failure Analysis

9. DB2 Non- Sysplex Failure Recovery

  • Member Failures
  • Catalog and Directory Failures
  • Application Failures
  • Attachment Failures
  • Short on Storage
    • SCA
    • Lock Structures
    • Group Buffer Pools

10. DB2 Sysplex Failure Recovery

  • CPC Failures
  • Structure Failures
  • CF Out of Space Conditions
  • Reallocating Structures
  • Timer Failures
  • Connectivity Failures

11. Disaster Recovery Considerations

  • Identify the type of Recovery Required
  • Disaster Backup Procedures
  • Preparing for Disaster Recovery
  • Coupling Facility Requirements