Should I Turn WLM I/O Priority Management On or Off?
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.
Db2 Accounting Data: Customized Dashboard Recap
A survey of a sample customized dashboard where key Accounting data charts have been collected. These dashboards can promote collaboration across teams, as well as serving as a springboard for additional analysis as the views are applied to other time intervals.
Db2 Accounting: Exploring Other Metrics in Accounting Data by Plan
A sampling of other types of metrics available in the Db2 Accounting data viewed by plan.
Db2 Accounting: Exploring Database Sync I/O Activity
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. Dynamic navigation to explore those waits at the levels of detail made possible from the Accounting data can greatly aid analysis.
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.).