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.
Offload table name
CQM_SUMM_METRICS
Column name
ACCEL_ELIGIBLE_CPU
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.
Offload table name
CQM_SUMM_METRICS
Column name
ACCEL_ELIGIBLE_ELAPSED
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.
Offload table name
CQM_SUMM_METRICS
Column name
ACCEL_ELIGIBLE_ZIIP
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.
Offload table name
CQM_SUMM_METRICS
Column name
ACCELERATOR
Authid
The primary authorization ID.
Offload table name
CQM_SUMM_METRICS
Column name
AUTHID
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)
Offload table name
not applicable
Column name
not applicable
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)
Offload table name
not applicable
Column name
not applicable
Avg Delay
The average delay time per SQL call.
Offload table name
not applicable
Column name
not applicable
Avg Getpages
The average number of getpages issued.
Offload table name
not applicable
Column name
not applicable
AvgX CPU
The average amount of CPU time for each execution count in Db2.
Offload table name
not applicable
Column name
not applicable
AvgX Delays
The average amount of delay time for each execution count in Db2.
Offload table name
not applicable
Column name
not applicable
AvgX Elapsed
The average amount of elapsed time for each execution count in Db2.
Offload table name
not applicable
Column name
not applicable
AvgX GetPages
The average of the getpages divided by the execution count.
Offload table name
not applicable
Column name
not applicable
Calls
The total number of individual SQL calls executed by Db2.
Offload table name
CQM_SUMM_METRICS
Column name
SQL_CALLS
Collection
The collection ID.
Offload table name
CQM_SUMM_METRICS
Column name
COLLECTION
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.