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.


More Db2 Accounting Videos

  1. Exploring Analysis by Connection Type
  2. Exploring Analysis by Correlation ID
  3. Exploring Elapsed Time Profiles
  4. Exploring Analysis by Authorization ID
  5. Exploring Prefetch Activity and Suspension Events
  6. Exploring Analysis by Plan or Package Name
  7. Exploring Database Sync I/O Activity
  8. Exploring Other Metrics in Accounting Data by Plan
  9. Accounting Data: Customized Dashboard Recap


Video Transcript

All right. So as we’ve explored the Db2 accounting data in this session, and we’ve looked at it, we saw we could do that by connection type. And then from there, kind of go down one of three paths, maybe correlation ID, maybe auth ID or plan or package name. And so doing that, we saw all different kinds of metrics, SQL statements by type, log throughput; here was by connection type. We spent a good time talking about the different types of prefetch requests, here’s CPU consumption and also elapsed times by I think this was the CICS transaction view that we did there. Top CPU by auth ID for the DDF work. Here we saw those spikes for that auth ID, and we saw that show up several times, right here. We showed it up in terms of suspension events. We looked at top CPU by plan for CICS, saw the profile for the top plans and kind of saw the bump in the evening, and when we looked across all connection types, except DDF, we saw there were some batch work that was doing a lot of CPU, but then again, we saw that CICS plan. And then since in CICS, when you drill down the correlation ID contains transaction IDs. And so we could then get in and see which transactions were generating the Db2 CPU. And we saw a couple of unusual profiles, including the transaction that’s generating the bumps at night. And then finally we looked at database sync I/Os by connection type. So when we come back, we want to revisit the analysis at a future date. We can view any of these views, update the time interval to a different time interval, and so throughout today, as we explore the accounting data, we saw that when working with massive data volumes as is certainly the case with Db2 accounting data and the context-sensitive drill downs are a great aid to learning and exploration because they provide the capability to easily navigate and focus quickly on the precise subset of data you want to analyze. Sometimes today we looked at it by connection type, sometimes by correlation ID, sometimes by auth ID, and sometimes by plan and package name.
So again, here are the types of metrics that we saw in the accounting data, and we viewed them again
with different subsets of the data, depending on the particular type of metric and the particular driver of the Db2 work, certain drill downs were more applicable. Auth ID was typically more helpful with DDF work plan, perhaps more for work coming from CICS or IMS, and so on.

Speak to a Technical Expert Today

Whether you are conducting product research, need support on a project, are experiencing downtime, or want to learn more about how IntelliMagic can support your business, our experts are here to help.

You May Also Be Interested In:


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.

Watch Webinar

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.


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.

Watch video

Explore Db2 Performance Management and Monitoring