This session suggests capabilities to keep in mind as you seek to modernize how you access and analyze your Db2 SMF data, both to promote rapid learning as well as boost the value you derive from your data.
Our learning journey will include:
- Leveraging automated assessments of key metrics
- Exploring the extensive buffer pool metrics provided by Db2
- Introducing the many types of metrics provided in the Statistics data
- Identifying important Db2 operational insights that can be derived from integration with other types of 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.