A brief walkthrough of a sample customized dashboard that provides easy accessibility into key Db2 Statistics metrics used to carry out buffer pool tuning initiatives. This type of dashboard enables team members to share a common view of all key metrics and facilitates future iterations of the analysis applied to different time intervals.
More Db2 Statistics Videos
- Exploring Assessments of Key Metrics
- Db2 Buffer Pool Tuning: Exploring Key Metrics (Part 1)
- Db2 Buffer Pool Tuning: Exploring Key Metrics (Part 2)
- Db2 I/O Cache Insights from IFCID 199 and SMF 42 Data
- Buffer Efficiency from IFCID 199 and SMF 42
- Measuring Benefits of Db2 Buffer Pool Tuning
- Exploring Other Db2 Statistics Metrics
- Walkthrough of Db2 Statistics Dashboard for Buffer Pool Tuning
- Integrating with RMF Metrics (70, 71, 72, 74)
- Integrating with RMF 70 and 72 CPU and WLM Metrics
- Integrating with RMF 71 Memory and Large Frame Metrics
- Integrating with RMF 74.4 Coupling Facility Metrics
Video Transcript
So, this is what we created today, right? We started out and found out that the I/O volumes were overwhelmingly in a particular data sharing group and they were overwhelmingly in the 4K pools. And then from there, we saw the buffer pool 20 was the highest I/O driver, so that was on a methodology that looked at I/O rate. If we look at residency times, again buffer pool 20 came out higher there, and then that’s how they compare to the hit ratios. And again, if we looked at hit ratios, buffer pool 20 came out there as well, and then cache hits and misses and buffer pool 20, the response time profile stayed relatively the same, no matter what was going on with the I/O rate. But the response times for databases were quite different across time there. And then this was the buffer efficiency metric looking at it by buffer pool, looking at it by database cache hits. We saw how that could figure in as kind of a second tier of access in our buffer pool tuning methodology. We saw that for buffer pool 20 DDF work was the dominant contributor. And then here were how those response time components, the key focus ones shaped up over time. So again, we could take any one of these, we can change the time interval and assess it further. So that’s kind of the value of the dashboard as well.
Learn More About Analyzing Db2 Statistics and Accounting Data
Speak to a Technical Expert Today
Whether you are conducting product research, need support on a project, are experiencing downtime, or want to learn more about how IntelliMagic can support your business, our experts are here to help.
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.