In this session on gaining insights from the Db2 SMF data series, we take a deep dive into the Db2 Accounting (SMF 101) data.
Our learning journey will include:
- Examining the differing profiles of work generated by the various callers of Db2 services (“connection type”), including CPU and SQL activity, suspend events, and elapsed time profiles
- Exploring the visibility provided by “correlation ID” into the specific drivers of Db2 activity (e.g., by CICS transaction, batch job, etc.)
- How focusing analysis of DDF work by “authorization ID” can help manage a challenging workload
- Introducing important Db2 operational insights from integration with other data types, including CICS transaction (SMF 110.1) data
You May Also Be Interested In:
Integrating Dataset Performance (SMF 42.6) and Db2 Buffer Pools & Databases (SMF 102/IFCID 199) Data
Dataset performance data from SMF 42.6 records provides disk cache and response time data at the Db2 buffer pool and Db2 database levels when integrated with Db2 Statistics IFCID 199 data.
Db2 GETPAGE Efficiency Integrating Dataset Performance (42.6) and Db2 IFCID 199 Data
Integrating Db2 IFCID 199 and SMF 42 data can be leveraged to create a view of overall Db2 GETPAGE efficiency along with several other key GETPAGE views and data.
Evaluating and Tuning Db2 Subsystem Wait (Suspension) Times
Understanding what causes wait (suspension) time can be instrumental in improving your subsystem and application performance.