Db2 Accounting: Exploring Analysis by Correlation ID
Db2 analysts frequently want to subset data by correlation ID so that they have easy visibility into the specific drivers of Db2 activity (e.g., by CICS transaction, batch job, etc.).
Integrating Db2 Data with RMF 74.4 Coupling Facility Metrics
High volume Db2 data sharing groups are very dependent on responsive coupling facility performance, giving Db2 teams keen interest in coupling facility metrics captured in the RMF 74.4 records.
Integrating RMF 71 Memory & Large Frame Metrics with SMF
Since Db2 is typically the largest exploiter of memory in general as well as of 1 MB and 2 GB large frames, visibility into memory, paging, and large frame metrics from RMF 71 data is of particular interest to Db2 teams.
Integrating Db2 Data and RMF 70 & 72 (CPU & WLM) Metrics
Insights into Db2 operation in areas such as WLM service goals and CPU utilization and consumption are provided by RMF 70 and 72 data.
Integrating Db2 SMF Data with RMF Metrics (70, 71, 72, 74)
Since Db2 interacts heavily with z/OS and other subsystems, “outside” perspectives provided by RMF metrics are essential to effectively manage Db2 operational health and performance.
Walkthrough of Db2 Statistics Dashboard for Buffer Pool Tuning
A brief walkthrough of a sample dashboard into Db2 Statistics metrics that enables team members to share a common view of all key metrics and provides easy accessibility to carry out buffer pool tuning initiatives.
Exploring Assessments of Key Db2 SMF Metrics
Automated assessments of key Db2 metrics facilitate proactive analysis and prevention of outages by identifying areas that may warrant investigation.
Exploring Other Db2 Statistics Metrics
A brief introduction to some of the “other” (non-buffer pool related) metrics available in Db2 Statistics data
How to Measure the Benefits of Db2 Buffer Pool Tuning
How to approach measuring the benefits of buffer pool tuning initiatives, which are likely to be primarily realized in this small set of average elapsed time metrics
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.