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.

You May Also Be Interested In:


What's New with IntelliMagic Vision for z/OS? 2024.2

February 26, 2024 | This month we've introduced changes to the presentation of Db2, CICS, and MQ variables from rates to counts, updates to Key Processor Configuration, and the inclusion of new report sets for CICS Transaction Event Counts.

Read more

Viewing Connections Between CICS Regions, Db2 Data Sharing Groups, and MQ Queue Managers

This blog emphasizes the importance of understanding connections in mainframe management, specifically focusing on CICS, Db2, and MQ.

Read more

What's New with IntelliMagic Vision for z/OS? 2024.1

January 29, 2024 | This month we've introduced updates to the Subsystem Topology Viewer, new Long-term MSU/MIPS Reporting, updates to ZPARM settings and Average Line Configurations, as well as updates to TCP/IP Communications reports.

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