A sampling of other 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


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

All right. Let’s look at a sampling. We mentioned again, lots of different metrics in the accounting data, and let’s look at a sampling of some of the other metrics available.

Here we have the rate of commits by plan.

Here we have the number of rollbacks by plan.

We can also look at the volume of log data. You know, some plans are continuously executing, others are used by batch jobs that have discreet start and end times.

We can also look at the volume of SQL statements by type for a plan. So let’s go down to that plan that had all the sync read I/Os. And so here’s the volume of SQL statements, opens, closes, fetches, and so on that generated by that plan.

Now earlier we viewed counts of suspension events for DDF work by auth ID. We can learn from exploring those suspension counts across all connection types.

For example, here’s a view of the way of the suspensions by connection type with DDF excluded. So for example, here, we see that the IMS message processing region work in this environment experiences far more global lock contention for parent L locks than the other connection types. And then from here, we can explore and see which applications, which plans are experiencing a lot of that global lock contention. If we instead want to view the suspension events by plan, here again we see this DQPS plan that we’ve seen a few times earlier, already.

And again, lots of sync I/O waits. We saw that earlier, but it also has many waits for other read I/O, which as we talked about earlier was associated with prefetch I/Os.

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