Video

Integrating Db2 IFCID 199 with 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.

Watch video
Video

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.

Watch video
Video

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.

Watch video
Video

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. This video explores key metrics for two other buffer pool tuning methodologies.

Watch video
Video

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.

Watch video
Video

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.

Watch video
Video

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.

Watch video
Video

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.

Watch video
Video

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.

Watch video