Understanding and Analyzing Db2 Statistics CPU Times and DBAT Activity
This article dives into the insights into CPU Usage and DBAT Activity that can be gleaned from advanced analysis of the SMF 100 Db2 statistics records.
How to Gather / Collect Db2 SMF Data
In this blog, for newcomers to Db2 analysis, we cover the crucial initial step for analyzing the data – how to gather and collect the SMF data in the first place.
Db2 Statistics - They're Not Just for Buffer Pools
Discover key insights Db2 statistics data can provide for performance management other than tuning Buffer Pools.
User Experience Leveraging Db2 SMF Data to Solve Business Problems | IntelliMagic zAcademy
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.
Implementing Asynchronous Duplexing in a Production Db2 Lock Structure - User Experience
Analyze the performance impacts of implementing asynchronous duplexing for Db2 lock structure in a high volume Db2 data sharing environment.
How to Achieve Higher Availability and Lower Performance Costs with Asynchronous Db2 Lock Structure Duplexing
In this Cheryl Watson Tuning Letter Reprint, Todd Havekost and Frank Kyne detail the unexpected performance benefits gained after one site implemented Asynchronous duplexing.
Imagine How Much You Can Learn Exploring Db2 Accounting Data | IntelliMagic zAcademy
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.
Db2 Accounting Data: Customized Dashboard Recap
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.
Db2 Accounting: Exploring Other Metrics in Accounting Data by Plan
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.
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.
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.