|
Effective exploitation of Buffer Pools is essential to achieving good Db2 performance, so it is key to effectively monitor Db2 buffer pool data.
|
|
This video demonstrates using Db2 IFCID 199 and SMF 42 data to gauge Db2 GETPAGE efficiency, showing percentages for buffer pool hits, disk cache hits, and actual disk I/Os.
|
|
IFCID 199 and SMF 42 data integration offers insights into buffer efficiency, breaking down buffer misses into cache hits and misses. This helps refine buffer pool tuning methods.
|
|
A brief introduction to some of the “other” (non-buffer pool related) metrics available in Db2 Statistics data
|
|
Automated assessments of key Db2 metrics aid proactive analysis, preventing outages by pinpointing areas needing investigation and highlighting crucial metrics for analysis.
|
|
Easy accessibility to key Db2 buffer metrics enhances buffer pool tuning analyses so that they can be quickly completed. This video explores key metrics for one buffer pool tuning methodology.
|