Home About Courses Schedule Services Webinars Contact Search

Db2 for z/OS System Monitoring and Performance Tuning


Duration: 3 Days

Method: Instructor led, Hands-on workshops

Price: $1920.00

Course Code: DB5005


Db2 Systems Programmers, Db2 Systems Administrators and Systems Database Administrators who will be monitoring and tuning Db2 for z/OS.


This course provides detailed guidance information for all personnel who will be participating in Db2 for z/OS Subsystem performance analysis and tuning. Both data sharing and non-data sharing considerations are covered. A Drill-down approach will be used to identify critical system bottlenecks.


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

  • Develop a Performance Monitoring Strategy
  • Implement a Drill Down Performance Approach
  • Identify and Tune System Level Performance Problems
  • Identify Thread Level Performance Issues
  • Assist DBAs and Application Personnel in Performance Tuning


A working knowledge of Db2 for z/OS at the System Level (DB5001).


  • I. Introduction to Performance Tuning
    • Planning your performance strategy
      • Continuous Monitoring
      • Periodic Monitoring
      • Detailed Monitoring
      • Exception Monitoring
    • Trace Types
    • Major Contributors to TCB/SRB Times
    • Statistics Report
    • Accounting Report
    • DSNTIPN Trace panel
    • Investigating Performance Problems
    • Drilldown Performance Tuning
      • Subsystem
      • Database
      • Application/Connections
      • SQL
  • II. Db2 System Services Address Space
    • Systems Services Address Space
    • ssnmMSTR Critical Resources
      • BSDS
      • Active Logs
      • Archive Logs
    • Managing the BSDS and Logs
    • Performance
    • Data Sharing Cache Storage
    • Critical zParms
  • III. Db2 Database Services Address Space
    • Database Services Address Space Overview
    • Db2 Database Objects Resource Usage
    • Tuning xxxxDBM1 Resources
      • EDM Pool
      • Buffer Pools
      • Buffer Pool Simulation
      • Sort Storage
      • Rid Pool Storage
    • Data Sharing Group Buffer Pools
    • Critical zParms
  • IV. Db2 Internal Resource Lock Manager and Concurrency Control
    • Db2 Resource Serialization
    • IRLM Address Space (xxxxIRLM)
    • Tuning your use of Locks
    • Data Sharing Lock Cache
    • Critical Lock Management zParms
  • V. Db2 Distributed Data Services
    • Connectivity Options
    • DDF Address Space (xxxxDIST)
    • TCP/IP Communication
    • Data Sharing Group
    • Distributed Performance
    • Critical zParms
  • VI. Db2 Thread Level Tuning
    • Accounting Trace for Thread Level Performance
    • Identify Bottlenecks
    • Major Contributors to High Elapsed Times
    • Providing Direction to your DBA and Applications Group
    • Critical zParms