Blog

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.

Read more
Video

Analysis of CPU By Plan: CICS Transaction (110.1) and Db2 Accounting (101) Part 2

Integrated visibility between Db2 Accounting and CICS Transaction data can correlate CICS transaction IDs driving high CPU in Db2 with the CICS profile of the transaction.

Watch video
Video

Elapsed Time Profiles by Correlation ID: CICS Transaction (110.1) and Db2 Accounting (101) Part 1

This video shows how viewing CICS Call Attach work by Correlation ID enables both CICS and Db2 teams to view elapsed time profiles within Db2 corresponding to each CICS transaction ID.

Watch video
Video

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.

Watch video
Blog

Evaluating and Tuning Db2 Subsystem Wait (Suspension) Times

Understanding what causes wait (suspension) time can be instrumental in improving your subsystem and application performance.

Read more
Webinar

Use Cases Leveraging Db2 Accounting Data to Optimize Your Environment | IntelliMagic zAcademy

This recording will equip you to enhance the value and insights you can derive from your own Db2 Accounting data.

Watch Webinar
Blog

Address Space and Db2 Accounting Data

Learn how address space (SMF 30) and Db2 Accounting (SMF 101) data provide a more complete “big picture” view when integrated than is available from either data source on its own.

Read more
Whitepaper Cheryl Watson's Tuning Letter

Learning from SMF: Db2 Buffer Pools

Dive into the SMF type 100 records to see what insights they offer into Db2 buffer pools. This whitepaper contains valuable information for relative newbies and experienced hands alike.

Download
Video

Db2 Accounting: Isolating Change Drivers Case Study

This video illustrates how Db2 SMF data can be leveraged to identify drivers of an observed reduction in elapsed time. This example isolates the change by authorization ID, buffer pool, and page set.

Watch video