Db2 for z/OS System Monitoring and Performance Tuning

COURSES / Db2 for z/OS System Monitoring and Performance Tuning

Db2 for z/OS System Monitoring and Performance Tuning

Duration: 3.0 days

Method: Instructor led, Hands-on workshops

Price: $1920.00

Course Code: DB5005

Audience

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

Description

The course provides detail 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.

Objectives

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

Prerequisites

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

Topics

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
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
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
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
Db2 Distributed Data Services
- Connectivity Options
- DDF Address Space (xxxxDIST)
- TCP/IP Communication
- Data Sharing Group
- Distributed Performance
- Critical zParms
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