Resources

For most shops, several key elements and options of the WLM service policy still remain unchanged from decades ago. This blog addresses whether one option, “I/O Priority Management” should be.

Customized Db2 Accounting dashboards can promote collaboration across teams, as well as serve as a springboard for additional analysis as the views are applied to other time intervals.

A sampling of several types of metrics available in the Db2 Accounting data viewed by plan such as rate of commits, number of rollbacks, volume of log data, volume of SQL statements by type, and more.

Avoiding database sync I/Os (achieved when getpages are satisfied from data already residing in a buffer) plays a prominent role in Db2 performance and efficiency.

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.

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.

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.

The many timing buckets captured in the Db2 Accounting data enable great visibility into the elapsed time profiles of work executing within Db2.

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.).

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.

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.

Insights into Db2 operation in areas such as WLM service goals and CPU utilization and consumption are provided by RMF 70 and 72 data.