Resources

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.

Learn how moving the compression function from PCIE-attached zEDC cards to the zEDC Accelerator has resulted in changes (reductions) in the metrics that are available.

Analyze the performance impacts of implementing asynchronous duplexing for Db2 lock structure in a high volume Db2 data sharing environment.

In this Cheryl Watson Tuning Letter Reprint, Todd Havekost and Frank Kyne detail the unexpected performance benefits gained after one site implemented Asynchronous duplexing.

For decades, the only way to read SMF data was to create your own SAS code that would generate output from SMF that could be understood. Technological innovations such as AI has made writing your own custom SAS code for SMF reports unnecessary for all but the most esoteric reports.

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.

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.