Db2 Accounting: Exploring Analysis by Plan or Package Name
Drilling into metrics at the plan (and package) levels which typically reflect alignment with business applications is often the preferred approach for detailed analysis of work coming from transaction managers like CICS and IMS.
Db2 Accounting: Exploring Prefetch Activity and Suspension Events
Examples of the benefits of dynamic navigation through Db2 Accounting data applied to metrics such as (a) prefetch activity by type and (2) counts of suspension (“wait”) events.
Db2 Accounting: Exploring Analysis by Authorization ID
Focusing analysis by authorization ID can be particularly helpful for insights into managing DDF work which is often challenging since it lacks many of the controls in place for other types of workloads.
Db2 Accounting: Exploring Elapsed Time Profiles
The many timing buckets captured in the Db2 Accounting data enable great visibility into the elapsed time profiles of work executing within Db2. This is particularly powerful when combined with the capability to easily subset this data by criteria captured in these records including connection type, correlation ID, authorization ID, and plan and package name.
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 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 such as service times and request and reclaim rates captured in the RMF 74.4 records.
Integrating with RMF 71 Memory and Large Frame Metrics
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 with RMF 70 and 72 CPU and WLM Metrics
Insights into Db2 operation are provided by RMF 70 data in areas such as CPU utilization and consumption at the processor and system levels. Several relevant areas are provided by RMF 72 data, including CPU consumption at the workload / service-class / report-class levels, WLM data relative to how service goals are being achieved and delays inhibiting that, and transaction metrics for DDF workloads which are often visible to WLM.
Integrating 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.