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. Case Study: Isolating Change Drivers
  9. Exploring Other Metrics in Accounting Data by Plan
  10. Accounting Data: Customized Dashboard Recap


Video Transcript

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:


Profiling zHyperLink Performance and Usage

In this blog, we demonstrate how to profile zHyperLink performance and usage by reviewing one mainframe site’s recent production implementation of zHyperLink for reads, for Db2.

Read more

How A Db2 Newbie Quickly Spotlights the Root Cause of a Db2 Slowdown

This blog explores how a non-Db2 expert quickly identified latch contention arising from a Data Sharing Index Split as the root cause of a Db2 delay/slowdown.

Read more

Integrating Dataset Performance (SMF 42.6) and Db2 Buffer Pools & Databases (SMF 102/IFCID 199) Data

Dataset performance data from SMF 42.6 records provides disk cache and response time data at the Db2 buffer pool and Db2 database levels when integrated with Db2 Statistics IFCID 199 data.

Read more

Explore Db2 Performance Management and Monitoring

Book a Demo or Connect With an Expert

Discuss your technical or sales-related questions with our mainframe experts today