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

Prerequisites

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