Know Db2

Db2 11 for z/OS Data Sharing - Implementation and Performance

The class will describe the concepts and components of a data sharing environment in Db2 for z/OS, the details of those data sharing components, performance tuning of the group buffer pools, lock structure and SCA (shared communications area) and detail performance monitoring and tuning of a Db2 Data Sharing environment.

Duration: 5 Day, Instructor Led Class

Audience: This advanced Db2 11 for z/OS course focuses on the tasks of the Db2 DBA’s, Db2 Systems Programmers, Operations Personnel, and staff that will be involved with Db2 data sharing implementation and performance tuning of this environment.

Prerequisites: Experience in Db2 for z/OS as a DBA, System Programmer, or Application Developer.

Labs: Hands-on labs and paper labs.

Class Material: Each student’s class book has the presentation slides with notes, as well as an exercise book with answer sets.

Course Objectives:

Db2 11 for z/OS Data Sharing - Implementation and Performance Class Outline:

Introduction to Data Sharing:

  • Describe the Sysplex Environment
  • What are the communication roles of XCF and XES
    in z/OS Parallel Sysplex
  • CFRM Policy definition and description
  • Define a z/OS parallel sysplex environment
  • Review and Labs

Coupling Facility Details:

  • Global locking and data
  • Group Buffer pools definitions
  • Shared Communication Area
  • P-Lock and the Effects on Page Sets
  • Physical Lock (P-Lock) definition
  • Page set and page P-locks details
  • P-Locks and changes to the state of a page
  • Components and hardware requirements
  • Review and Labs

Db2 Data Sharing Details:

  • Components and hardware requirements
  • Discuss Db2 data sharing benefits
  • Overview of Db2 data sharing
  • Explain the Db2 Data sharing environment
  • What Db2 data sharing group will share and does not share
  • Define a z/OS parallel sysplex environment, the components, and hardware requirements
  • Incorporate and describe RACF use in a data sharing environment
  • Prepare your data sharing environment, the prerequisites, and strategy
  • Naming strategy and why
  • Review and Labs

Db2 Data Sharing Planning Strategy:

  • Data Sharing prerequisites to meet
  • Naming conventions
  • Estimating the storage needs
  • Storage for coupling Facility structures
  • Review and Labs

Data Sharing Installation:

  • Plan the Installation and migration of a new data sharing enabled Db2
  • Add a new data sharing member
  • How to enable data sharing on a running Db2
  • Working with the installation CLIST
  • How to create a new data sharing group
  • Review and Labs

How to Migrate to Data Sharing:

  • Review of the migration procedures
  • Identifying changes or new features
  • Data sharing and disabling its use
  • Identifying problems related to disabling
  • Removing a data sharing member
  • Review and Labs

Db2 11 Data Sharing Enhancements:

  • Data sharing enhancement s in Db2 11
  • Restart light - Castout
  • Locking, deadlock cycle, hash table
  • Index, split performance
  • Group buffer pool / Castout
  • How Sysplex Query Parallelism is delivered
  • How we order products from IBM
  • Review and Labs

Getting Data into a Data Sharing Group:

  • Db2 Utilities and their use in data sharing
  • What utilities do you use and why
  • Data in a Data Sharing Group
  • Working with the LOAD utility
  • Using DSN1COPY
  • Using DSNTIAUL
  • REPAIR Utility
  • Rename a member
  • Deactivate a member of a data sharing group
  • Destroy a member from a data sharing group
  • Reactivate a deactivated member of a data sharing group
  • Review and Labs

Data Sharing in a Distributed Environment:

  • Connect process to a data sharing group
  • TCP remote requests
  • SNA remote requests
  • Workload balancing
  • CDB tables and network protocols
  • Review and Labs

Monitoring - Db2 Data Sharing:

  • Components used by Db2 data sharing
  • Evaluate and use the output of z/OS and Db2 data sharing related commands
  • Coupling Facility Monitoring
  • Db2 structures in the Coupling Facility
  • Review and Labs

Data Sharing Performance Techniques:

  • Db2 data sharing performance objectives
  • Performance factors in Data Sharing
  • CF performance factors
  • Group buffer pool tuning
  • Commands to know and use
  • Setting new thresholds
  • Lock structure tuning and monitoring
  • Developing a methodology for monitoring
  • Monitoring - useful techniques and products
  • Performance Problems – a walk through
  • Review and Labs
  • Class Summary Review
  • ©2017 Computer Business International, Inc.


Would you like to schedule or customize this class?
Please call our toll free number (866-224-4968) or email us at