Resources

A comprehensive solution that is suitable for everyone from executives looking for cost savings and managing availability risks, to the experienced analyst looking for the most detailed insights.

This session suggests capabilities to keep in mind as you seek to modernize how you access and analyze your Db2 SMF data, both to promote rapid learning as well as boost the value you derive from your data.

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.

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.

A sampling of other types of metrics available in the Db2 Accounting data viewed by plan.

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.

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.