Db2 13 for z/OS System Performance Tuning

Dec 10, 2024 at 9:00am to Dec 12, 2024 at 5:00am EST
Location: Vitrual
Categories: Db2
Latest Activity: Sep 13

Audience

This course is intended for DBAs and systems programmers.

Prerequisites

Students should have attended the Db2 for z/OS Administration and Db2 for z/OS SQL Performance and Tuning courses.

Duration

3 Days. Hands on.

Course Objectives

The course provides detailed coverage of System Performance Tuning for Db2 for z/OS. It is applicable to all recent versions of Db2 up to and including Db2 13. The course includes labs and demonstrations using online Db2 performance monitors and workshops.

Course Benefits

It is commonly accepted that the performance of any Db2 application is largely dependent on efficient database design and application coding. Having said that, a poorly tuned Db2 system can undermine the efforts of the development team.
This course will help production DBAs and Systems Programmers ensure they provide an optimally tuned environment for their Db2 workload. It will guide them in collaborating with colleagues working with z/OS, CICS, IMS, WebSphere etc. to achieve the right balance between throughput and response times. They will be confident in interpreting Db2 Statistics trace data in order to carry out the appropriate tuning actions.

Course Content

Introduction
Factors determining performance.
Performance Objectives.

Db2 Architecture
Db2 Address Spaces.
Db2 Resource Managers.
Connections and Threads.
Serialisation Mechanisms.
Resource Accounting.
Data Sharing Architecture.

System Resource Factors
Virtual Storage Requirements.
Db2 System Parameters.
Allied Address Spaces.
Db2 and z/OS Workload Manager.
Coupling Facility Considerations.

Monitoring & Reporting
Db2 Instrumentation Facility.
Statistics, Accounting, and Performance Traces.
Db2PE Statistics Report.
Monitoring Storage Use.

Buffer Pool Processes
Buffer Pool Basics.
Getpage Processing.
Sequential, Dynamic, and List Prefetch.
Parallelism.
Db2 Sort.
Buffer Pool Thresholds.
Group Buffer Pools.

Monitoring &Tuning the Buffer Pools
Buffer Pool Assignments.
Buffer Pool Settings.
Prefetch and Parallelism.
Monitoring and Tuning the Local and Group Buffer Pools.

The EDM Pools
EDM Pool and DBD Cache.
Dynamic Statement Caching.
EDM Pools Monitoring and Tuning.

Log Buffers
Commit Processing.
Forward Recovery and Rollback.
Active Log, Archive Log, and BSDS.
Checkpoints.
Fast Log Apply.
Monitoring and Tuning Db2 Logging.

Transaction Locking
Lock Size, Mode, and Duration.
Tablespace Locks.
Page and Row Locks.
Data Sharing Global Locking.
Lock Avoidance.
Page Latching, C_LSN, and PUNC.
IRLM.
Locking Parameters.
LOB Locking.
Application Issues.
Monitoring and Tuning Locking.

Other Serialisation Mechanisms
Partition Independence.
Claim and Drain.
Restrictive States.
Monitoring Claim and Drain.

Db2 Attachments
The TSO, CICS, IMS, and Call Attaches.
Two Phase Commit.
Monitoring and Tuning the Attaches.
High Performance Database Access Threads.

DDF, SPs, and UDFs

Utilities and Special Processes
Utility Performance Factors.
Utility Serialisation.
Load, Reorg, Copy, Recover, and Runstats.
Monitoring Utilities.
Db2 Catalog and Directory.
Utility History.

Using RMF for System Monitoring

https://bit.ly/Db2-13PerformanceDec10th-12th

Any questions contact: Surekha Parekh Independant Consultant (Ex IBM WW Db2 for z/OS Program Director)