Integrating Db2 IFCID 199 with SMF 42 Dataset Performance Data
A primary benefit of integrating Db2 SMF 42 data with IFCIP 199 is exploring that when it getpage cannot be satisfied from a buffer and thus a sync read IO occurs, what are the performance characteristics of that IO?
Db2 Accounting Data: Exploring Analysis by Connection Type
Learn what insights you can gain by exploring Db2 Accounting Data by Connection Type.
Db2 Buffer Pool Tuning: Analysis by Connection Type
See how to analyze and tune Db2 buffer pools by viewing the SMF data aggregated by connection type.
Db2 Buffer Pool Tuning: Measuring Benefits
Learn what insights you can gain into Db2 Buffer Pool tuning by viewing the elapsed time profile for the work coming from CICS over time
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
Change Detection and Health Assessments (based on pre-defined best practice conditions) play complementary roles, but there can be scenarios where they both flag issues. This use case with CICS Max Tasks is one such example.
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.