Buffer Efficiency from Integrating IFCID 199 and SMF 42 Data
Integrating IFCID 199 and SMF 42 data provides a view of buffer efficiency enabling buffer misses (I/Os) to be further subdivided into cache hits and misses, which can be leveraged to further refine buffer pool tuning methodologies.
Db2 I/O Cache Insights from IFCID 199 and SMF 42 Data
Integrating IFCID 199 and SMF 42 data provides extensive insights into I/O cache characteristics and response time data at the Db2 buffer pool and Db2 database levels.
Db2 Accounting: Exploring Analysis by Connection Type
The profiles of work generated by the various callers of Db2 services often differ dramatically, highlighting the importance of dynamic navigation enabling great visibility into Db2 metrics by connection type.
Db2 Buffer Pool Tuning: Exploring Key Metrics (Part 1)
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.
Db2 Buffer Pool Tuning: Exploring Key Metrics (Part 2)
Easy accessibility to key Db2 buffer metrics simplifies buffer pool tuning analyses, increasing the likelihood they will be periodically revisited using data from new time intervals.
Health Insights and Change Detection
To help enhance the value you can derive from that SMF data, IntelliMagic Vision provides two complementary types of automated anomaly detection: health insights and change detection.
CICS Max Tasks: Automated Change Detection Use Case 7
View a CICS Max Tasks use case where Change Detection and Health Assessments play complementary roles in flagging serious issues.
Batch Job Elapsed Time: Automated Change Detection Use Case 6
Elapsed and CPU times can be of interest for batch jobs, especially those on the critical path for key business job cycles. This use case reflects an abnormally long run time for a daily batch job, and illustrates how potential causes might be investigated.
Coupling Facility Request Rate: Automated Change Detection Use Case 5
Key coupling facility performance metrics at the structure level include synchronous and asynchronous request rates and service times, making them attractive candidates for Change Detection.
Db2 Getpage Rate: Automated Change Detection Use Case 4
“Getpages” are a primary indicator of Db2 activity, reflecting the count of operations to access data in a page. This use case illustrates the identification of a significant increase of Getpages.
CICS CPU Per Transaction: Automated Change Detection Use Case 3
This example investigates significant increases in CPU per transaction for selected transactions, isolated to specific CICS regions.
CPU by WLM Importance Level: Automated Change Detection Use Case 2
This video investigates the address space(s) driving an unanticipated spike in CPU consumption for the highest importance “Systems” work.