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.
ESM Enterprise Executive Interview with Els Das and Brent Phillips
IntelliMagic's co-founder and CEO, Els Das, alongside Managing Director, Brent Phillips, (virtually) sit down with ESM's Denny Yost to discuss the full gambit of mainframe performance topics, old and new.
Understanding and Analyzing Db2 Statistics CPU Times and DBAT Activity
This article dives into the insights into CPU Usage and DBAT Activity that can be gleaned from advanced analysis of the SMF 100 Db2 statistics records.
How to Gather / Collect Db2 SMF Data
In this blog, for newcomers to Db2 analysis, we cover the crucial initial step for analyzing the data – how to gather and collect the SMF data in the first place.
Just Say No: A Case for Eliminating I/O Priority Management | IntelliMagic zAcademy
WLM I/O Priority has been around for a long time and is in use at many data centers, but many sites are not even clear on what the setting does.
Db2 Statistics - They're Not Just for Buffer Pools
Discover key insights Db2 statistics data can provide for performance management other than tuning Buffer Pools.
How Long is Too Long? Multi-period Service Classes | IntelliMagic zAcademy
Multiple periods are one of the most powerful – and dangerous – tools in the performance analyst’s arsenal. They can ensure critical work gets done and runaway work can’t take over.
Selected MQ Accounting Data SMF Metrics – Part 2
Examples of various SMF metrics captured in MQ Accounting data that provide insights into detailed MQ activity.
Selected MQ Accounting Data SMF Metrics – Part 1
Examples of the key SMF metrics captured in MQ Accounting data including buffer pools, Thread Elapsed Time, CPU, elapsed time per get, etc.
Viewing MQ Accounting Data by Connection Type
Examples of how MQ Accounting data is commonly viewed by the connection type of the MQ caller, and additional levels of detail that are available by connection type.
Viewing MQ Accounting Data by Queue Level
Examples of ways value can be derived from MQ Accounting data by analyzing views broken out by MQ queue name.
Overview of MQ Accounting Data
Examples of how various MQ Statistics and MQ Accounting metrics can be collected and organized in customizable dashboards.