Column descriptions - Summaries (CAE Browser Client)
This topic describes the columns that are shown on the various Summaries displays. The columns that display depend on the drill down path taken.
- Accel Elig CPU
- The amount of CPU time spent on a non-specialty engine that could be saved if the statement or call were to run on an accelerator. This column contains a value only if the statement or call is eligible to run on an accelerator.
- Accel Elig Elapsed
- The amount of elapsed time that could be saved if the statement or call were to run on an accelerator. This column contains a value only if the statement or call is eligible to run on an accelerator.
- Accel Elig ZIIP
- The amount of CPU time spent on a specialty engine that could be saved if the statement or call were to run on an accelerator. This column contains a value only if the statement or call is eligible to run on an accelerator.
- Accelerator
- The name of the IBM® Db2 Analytics Accelerator for z/OS® where the activity might run. When the ACCELERATOR column is blank for a line item, it means that no queries for that line item were offloaded to the accelerator.
- Authid
- The primary authorization ID.
- Avg CPU
- The average CPU time each SQL call spent in Db2. Avg CPU = (Total CPU for this object)/(Total SQL instructions for this object)
- Avg Elapsed
- The average amount of elapsed time each SQL call spent in Db2. Avg Elap = (Total Elap for this object)/(Total SQL instructions for this object)
- Avg Delay
- The average delay time per SQL call.
- Avg Getpages
- The average number of getpages issued.
- AvgX CPU
- The average amount of CPU time for each execution count in Db2.
- AvgX Delays
- The average amount of delay time for each execution count in Db2.
- AvgX Elapsed
- The average amount of elapsed time for each execution count in Db2.
- AvgX GetPages
- The average of the getpages divided by the execution count.
- Calls
- The total number of individual SQL calls executed by Db2.
- Collection
- The collection ID.
- Connname
- The connection name.
- Conntype
- The Db2 connection type. Valid connection types include: 1 - TSO (TSO Foreground and Background), 2 - DB2CALL (DB2 Call Attach), 3 - IMSDLI (DL/I Batch), 4 - CICS® (CICS Attach), 5 - IMSBMP (IMS Attach BMP), 6 - IMSMMP (IMS Attach MPP), 7 - DB2PRIV (DB2 Private Protocol), 8 - DRDA (DRDA Protocol), 9 - IMSCTL (IMS Control Region), A - IMSTRAN (IMS Transaction BMP), B - UTILITY (DB2 Utilities), and C - RRSAF (RRSAF Attach).
- Contoken
- The hexadecimal value of the consistency token.
- Corrid
- The correlation ID.
- Corrname
- The correlation ID adjusted by the conventions used by IMS and CICS.
- %CPU
- The percent CPU time SQL calls (for a line item) spent in Db2 relative to the total CPU time that all SQL calls spent in Db2:
%CPU = 100.0 * ((CPU for this object)/(SUM of all objects CPU))
- <%CPU>
- The percent CPU usage for the SQL calls (for a line item) relative
to the total elapsed time for the SQL calls (for the line item):
<%CPU> = 100.0 * ((CPU Usage for this object)/(Total Elapsed Time for this object))
- CPU
- The total amount of CPU time SQL calls spent in Db2.
- DB2 SSID
- The Db2 subsystem on which the activity occurred.
- %Delay
- The percent delay time for SQL calls (for a line item) relative
to the total elapsed time for those SQL calls.
%DELAY = 100.0 * ((DELAY for this object)/(SUM of all objects DELAYS))
- <%DLY>
- The percent of delay time for the SQL calls (in a line item) relative
to the total elapsed time for those SQL calls:
<%Dly> = 100.0 * ((DELAY for this object)/(Total Elapsed Time for this object))
- Delay
- The total time SQL calls (for a line item) spent in delays (due to lock or latch delays, synchronous I/O delays, read/write delays).
- Dynamic Prefetch Requests
- The number of DYNAMIC PREFETCH requested for the object.
- %Elap
- The percentage of elapsed time SQL calls spent in Db2 relative to the total elapsed time all SQL calls spent in Db2.
- Elapsed
- The accumulated elapsed time while executing within Db2.Note: The elapsed time in Operational Summaries is the elapsed time of the duration of entire SQL calls and the elapsed time in Structural Summaries is the elapsed time of GETPAGE operations.
- Execution Count
- The number of times the SQL statement has executed. Db2 Query Monitor does not update the execution count for SQL that does not have a CLOSE call (for example, if the SQL ends with a negative SQLCODE or the SQL is canceled). In this case, the execution count of the SQL is shown as zero.
- Failed
- The number of times a parallel query failed to find a page in the buffer pool.
- GetPages
- The number of getpage requests. This includes conditional, unconditional, successful, and unsuccessful requests.
- GETPAGE Fail
- The number of times a parallel query failed to find a page in the buffer pool.
- Jobname
- The name of the job.
- Latch Delay
- The accumulated wait time due to page latch contention.
- Latch Suspensions
- The number of suspensions due to latch conflicts.
- List Prefetch Req
- The number of LIST PREFETCH requested.
- Lock Deadlocks
- The number of lock deadlocks.
- Lock Delay
- The number of lock delays.
- Lock Event
- The number of lock events detected for the object.
- Lock or Latch Delays
- The accumulated lock and latch elapsed wait time for lock and latch suspensions.
- Lock Suspensions
- The number of suspensions due to locking conflicts.
- Lock Timeouts
- The number of lock timeouts.
- Log Write I/O Evt
- The number of log write IO events detected.
- Log Write IO Delay
- The total amount of log write IO delay time for the object spent in Db2.
- LstPftch
- The number of LIST PREFETCH requests for the object.
- Open/Close Delays
- The Db2 service waits for OPEN/CLOSE DATASET.
- Other Read Delays
- The accumulated wait time for read I/O.
- Other Write Delays
- The accumulated wait time for write I/O.
- Package Version
- The package version associated with the SQL statement.
- Page Latch Delay
- The total amount of page latch delay time for the object spent in Db2.
- Page Latch Event
- The number of page latch events detected for the object.
- Parallel
- Indicates whether or not the SQL activity was formulated using Db2 query parallelism.
- Plan
- The Db2 plan name.
- Program
- The Db2 package or DBRM name.
- Sect #
- The section number.
- SeqPftch
- The number of SEQ PREFETCH requested for the object.
- Service Task Switch Delays
- The accumulated wait time due to synchronous execution unit switch to Db2 services.
- Schema
- The current schema that executed the SQL.
- SP Creat
- The creator of the stored procedure.
- SP Name
- The name of the stored procedure.
- SQL Text
- The abbreviated view of the SQL text.
- SQLCalls
- The number of SQL calls that occurred for the displayed activity.
- StdDev CPU
- The rolling standard deviation of the CPU time for a line item. In the Activity
Browser > Summaries data table, the StdDev
CPU field shows the value "N/A" when you are viewing data for archive connections. You
can calculate this metric if required, by querying the CQM_SUMM_METRICS table. For example, to
calculate StdDev CPU time where group_by is the metric by
which you want to group information (plan, program, etc) you can use the following query:
with MEAN(group_by,AVERAGE_MEAN_CPU) as (
select group_by,sum(cast(DB2_CPU_COUNT*DB2_CPU_MEAN as
double))/sum(cast(DB2_CPU_COUNT as double))
from SYSTOOLS.CQM_SUMM_METRICS group by group_by
)
select sqrt((sum(cast(DB2_CPU_DELTA_SQR as double)) +
sum(cast(DB2_CPU_COUNT as double) * power(DB2_CPU_MEAN -
MEAN.AVERAGE_MEAN_CPU,2))) / sum(cast(DB2_CPU_COUNT as
double)))
from SYSTOOLS.CQM_SUMM_METRICS left join MEAN
on SYSTOOLS.CQM_SUMM_METRICS.group_by = MEAN.group_by
group by SYSTOOLS.CQM_SUMM_METRICS.group_by; - StdDev Elapsed
- The rolling standard deviation of the elapsed time for a line item. In the Activity Browser > Summaries data table, the StdDev Elapsed field shows the value "N/A" when you are viewing data for archive connections, but if needed, you can calculate this metric. For an example of such a calculation, refer to the query in the description of StdDev CPU.
- StdDev Getpages
- The rolling standard deviation of the getpages for a line item. In the Activity Browser > Summaries data table, the StdDev Getpages field shows the value "N/A" when you are viewing data for archive connections, but if needed, you can calculate this metric. For an example of such a calculation, refer to the query in the description of StdDev CPU.
- Stmt#
- The SQL statement number assigned by the Db2 pre-compiler to an individual SQL call.
- Sync I/O Evt
- The number of synchronous IO events detected for the object.
- Sync I/O Dly
- The total amount of Sync IO delay time for the object spent in Db2.
- Synchronous I/O Delays
- The accumulated elapsed wait time for I/O. Synchronous I/O delays are further broken-down into Database I/O Delays and Log Write I/O Delays.
- SyncReads
- The number of synchronous read I/O for the object.
- SyncWrites
- The number of synchronous write I/O for the object.
- Table Creator
- The table creator associated with the activity.
- Table Name
- The table name associated with the activity.
- Type
- The type of object. Valid values are TABLE and INDEX.
- <%UAT>
- The percent unaccounted time (the amount of time not accounted for by SQL calls). Represents the
time for which Db2 does not track or
report statistics.
<%UAT> = 100 * (((Total Elapsed Time) - (Total Delay Time + DB2 CPU Time))/(Total Elapsed Time))
- Workstation Name
- The workstation name.
- Workstation Tran
- The workstation transaction.
- Workstation User
- The workstation user.
- WrteEvnt
- The number of log write IO events detected.
- <%zIIP>
- The percent zIIP.
- zIIP CPU
- The amount of CPU time accumulated while executing in Db2 on a zIIP processor.