Monitoring the use of accelerators for Db2 for z/OS queries

You can use Db2 traces to monitor how Db2 uses query accelerators.

To monitor the use of query accelerators:

• Use the accounting trace.
  The Db2 accounting class 1 trace records provide information about how often accelerators were used and how often accelerators failed.
• Use the statistics trace.
  The Db2 statistics class 1 trace provides:

  • The states of the accelerators that are in use
  • The amount of processing time that is spent in accelerators
  • Counts of the amounts of sent and received information
  • Counts of the number of times that queries were successfully and unsuccessfully processed by accelerators
  • The amount of time that statements spent waiting for delay protocols, and counts of statements that did not complete because time limits were exceeded for those delay protocols
  • The CPU and zIIP time consumed by Db2 asynchronous log reader tasks to read log records for incremental updates requested by accelerators using the Integrated Synchronization method.