Column descriptions - Exceptions (CAE Browser Client)

This topic describes the columns that are shown on the Exception display.

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_EXCEPTIONS
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_EXCEPTIONS
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_EXCEPTIONS
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 IBM Db2 Analytics Accelerator for z/OS.
Offload table name
CQM_EXCEPTIONS
Column name
ACCELERATOR
Acctg Token
The accounting token.
Offload table name
CQM_EXCEPTIONS
Column name
ACCOUNTING_TOKEN
Alerts
If an alert event exceeds an alert threshold, this field displays a string of codes indicating the type of alerts encountered during the execution of an SQL statement within Db2. Data entered within a monitoring profile defines the alerts. The codes for alert classes include:
C
Db2 CPU Time threshold exceeded
E
Db2 Elapsed Time threshold exceeded
G
GETPAGE threshold exceeded
Q
SQLCODE exception raised
S
SQL Calls threshold exceeded
L
Db2 Elapsed Time anomaly detected
P
Db2 CPU Time anomaly detected
T
GETPAGE anomaly detected

If more than one event class raises a flag, there will be more than one code displayed in this field. For example, if a row is displayed for a statement that exceeds the Elapsed time threshold, the CPU Time threshold, the GETPAGES threshold and also a -805 SQLCODE, the EXCEPTIONS field would display CEGQ.

Note: The same codes are used in both the EXCEPTIONS and ALERTS columns. However, due to differences in monitoring profile specification, the two columns might not contain the same information (for example, the elapsed time threshold for an ALERT might be set significantly higher than the threshold for an EXCEPTION).
Offload table name
not applicable
Column name
not applicable
ACPU RollLm (ACPU Roll Limit)
The tolerance level that would have to be crossed in order for a SQL statement to generate an anomaly alert for CPU.
Number format
6 digits after the decimal place are shown. Values smaller than 6 digits after the decimal place (.000001) are shown as zeros.
Calculation
ACPU RollLm = (StdDev CPU * Toleration Level for Alerts + RollAv CPU)
Exception
The P (Db2 CPU Time anomaly detected) exception is triggered when Db2 CPU Time exceeds ACPU RollLm.
Offload table name
CQM_EXCEPTIONS
Column name
ACPU_ROLLLM
AElap RollLm (AElapsed Roll Limit)
The tolerance level that would have to be crossed in order for a SQL statement to generate an anomaly alert for elapsed time.
Number format
6 digits after the decimal place are shown. Values smaller than 6 digits after the decimal place (.000001) are shown as zeros.
Calculation
AElap RollLm = (StdDev Elapsed * Toleration Level for Alerts + RollAv Elapsed)
Exception
The L (Db2 Elapsed Time anomaly detected) exception fires when Db2 Elapsed becomes larger than AElap RollLm.
Offload table name
CQM_EXCEPTIONS
Column name
AELAP_ROLLLM
AGetpgs RollLm (AGetpages Roll Limit)
The tolerance level that would have to be crossed in order for a SQL statement to generate an anomaly alert for getpages.
Number format
2 digits after the decimal place are shown. Values smaller than 2 digits after the decimal place (.01) are shown as zeros.
Calculation
AGetpgs RollLm = (StdDev Getpages * Toleration Level for Alerts + RollAv Getpages)
Exception
The T (GETPAGE anomaly detected) exception fires when GETPAGES becomes larger than AGetpgs RollLm.
Offload table name
CQM_EXCEPTIONS
Column name
AGETPGS_ROLLLM
ASQLCode
The SQL code that raised an alert condition. Alert criteria are defined within a monitoring profile.
Offload table name
CQM_EXCEPTIONS
Column name
ALERT_SQLCODE
Authid
The primary authorization ID.
Offload table name
CQM_EXCEPTIONS
Column name
AUTHID
Avg Getpages
The average number of getpages issued.
Call Type
The type of SQL call executed by a package or DBRM within Db2 (for example, PREPARE, OPEN, FETCH, etc).
Offload table name
CQM_EXCP_CALLS
Column name
TYPE
Child
Indicates whether the exception is related to another (parent) exception.
Collection
The collection ID.
Offload table name
CQM_EXCEPTIONS
Column name
COLLECTION
Connname
The connection name.
Offload table name
CQM_EXCEPTIONS
Column name
CONNECTION
ConToken
The hexadecimal consistency token.
Offload table name
CQM_EXCEPTIONS
Column name
CONSISTENCY_TOKEN
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).
Offload table name
CQM_EXCEPTIONS
Column name
CONNECTION_TYPE
Coordinator
The DB2 subsystem name acting as the parallelism coordinator for a parallel task.
Corrid
The correlation ID.
Offload table name
CQM_EXCEPTIONS
Column name
CORRID
Corrname
The correlation ID adjusted by the conventions used by IMS and CICS.
Offload table name
CQM_EXCEPTIONS
Column name
CORRNAME
Corrnum
The correlation number which is set based on the default OMEGAMON® parsing of the CORRID value.
Offload table name
CQM_EXCEPTIONS
Column name
CORRNUM
CPU
The accumulated total of all TCB and SRB CPU time spent executing in Db2.
Offload table name
CQM_EXCEPTIONS
Column name
DB2_CPU
CPU Discarded
Indicates whether or not the value of the CPU for a given SQL statement was not factored in to the rolling mean and standard deviation.
Offload table name
CQM_EXCEPTIONS
Column name
CPU_DSC
CPU Discard Threshold
The discard level that would have to be crossed in order for a SQL statement's CPU time not to update the rolling mean and standard deviation.
Offload table name
CQM_EXCEPTIONS
Column name
CPU_DSCT
CPU Factor
The amount of standard deviations from the mean the CPU was at the time the exception was generated.
Offload table name
CQM_EXCEPTIONS
Column name
CPU_FACTOR
Cursor Name
The cursor name.
DB2 SSID
The DB2 subsystem on which the activity occurred.
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).
Delay Count
The total number of delay events encountered.
ECPU RollLm (ECPU Roll Limit)
The tolerance level that would have to be crossed in order for a SQL statement to generate an anomaly exception for CPU.
Number format
6 digits after the decimal place are shown. Values smaller than 6 digits after the decimal place (.000001) are shown as zeros.
Calculation
ECPU RollLm = (StdDev CPU * Toleration Level for Exceptions + RollAv CPU)
Exception
The P (Db2 CPU Time anomaly detected) exception is triggered when Db2 CPU Time exceeds ECPU RollLm.
Offload table name
CQM_EXCEPTIONS
Column name
ECPU_ROLLLM
EElap RollLm (EElapsed Roll Limit)
The tolerance level that would have to be crossed in order for a SQL statement to generate an anomaly exception for elapsed time.
Number format
6 digits after the decimal place are shown. Values smaller than 6 digits after the decimal place (.000001) are shown as zeros.
Calculation
EElap RollLm = (StdDev Elapsed * Toleration Level for Exceptions + RollAv Elapsed)
Exception
The L (Db2 Elapsed Time anomaly detected) exception fires when Db2 Elapsed exceeds EElap RollLm.
Offload table name
CQM_EXCEPTIONS
Column name
EELAP_ROLLLM
EGetpgs RollLm (EGetpages Roll Limit)
The tolerance level that would have to be crossed in order for a SQL statement to generate an anomaly exception for getpages.
Number format
2 digits after the decimal place are shown. Values smaller than 2 digits after the decimal place (.01) are shown as zeros.
Calculation
EGetpgs RollLm = (StdDev Getpages * Toleration Level for Exceptions + RollAv Getpages)
Exception
The T (GETPAGE anomaly detected) exception fires when GETPAGES becomes larger than EGetpgs RollLm.
Offload table name
CQM_EXCEPTIONS
Column name
EGETPGS_ROLLLM
Elapsed Discarded
Indicates whether or not the value of the elapsed time for a given SQL statement was not factored in to the rolling mean and standard deviation.
Offload table name
CQM_EXCEPTIONS
Column name
ELAP_DSC
Elapsed Discard Threshold
The discard level that would have to be crossed in order for a SQL statement's elapsed time not to update the rolling mean and standard deviation.
Offload table name
CQM_EXCEPTIONS
Column name
ELAP_DSCT
Elapsed Factor
The amount of standard deviations from the mean the elapsed time was at the time the exception was generated.
Offload table name
CQM_EXCEPTIONS
Column name
ELAP_FACTOR
Elapsed
The accumulated elapsed time while executing within DB2.
End Time
The date and time that an individual SQL statement finished executing its last SQL call.
Offload table name
CQM_EXCEPTIONS
Column name
END_TIME
ESQLCode
The SQL code that raised an exception condition. Exception criteria are defined within a monitoring profile.
Offload table name
CQM_EXCEPTIONS
Column name
EXCEPTION_SQLCODE
Exceptions
If an exceptional event exceeds an exception threshold, this field displays a string of codes indicating the type of exceptions encountered during the execution of an SQL statement within Db2. Data entered within a monitoring profile defines the exceptions. The codes for event classes include:
C
Db2 CPU Time threshold exceeded
E
Db2 Elapsed Time threshold exceeded
G
GETPAGE threshold exceeded
Q
SQLCODE exception raised
S
SQL Calls threshold exceeded
L
Db2 Elapsed Time anomaly detected
P
Db2 CPU Time anomaly detected
T
GETPAGE anomaly detected
If more than one event class raises a flag, there will be more than one code displayed in this field. For example, if a row is displayed for a statement that exceeds the Elapsed time threshold, the CPU Time threshold, the GETPAGES threshold and also a -805 SQLCODE, the EXCEPTIONS field would display CEGQ.
Note: The same codes are used in both the EXCEPTIONS and ALERTS columns. However, due to differences in monitoring profile specification, the two columns might not contain the same information (for example, the elapsed time threshold for an ALERT might be set significantly higher than the threshold for an EXCEPTION).
Offload table name
not applicable
Column name
not applicable
Getpages
The number of getpage requests. This includes conditional, unconditional, successful, and unsuccessful requests. The GETPAGE information for a program reported on the activity summary might not add up to the sum of object detail GETPAGEs of that program due to the trade-off between optimizing the collector for efficiency and increasing the level of detail in some statistics.
Offload table name
CQM_EXCEPTIONS
Column name
GETPAGES
Getpages Discarded
Indicates whether or not the value of the getpages for a given SQL statement was not factored in to the rolling mean and standard deviation.
Offload table name
CQM_EXCEPTIONS
Column name
GETPGS_DSC
Getpages Discard Threshold
The discard level that would have to be crossed in order for a SQL statement's getpages not to update the rolling mean and standard deviation.
Offload table name
CQM_EXCEPTIONS
Column name
GETPGS_DSCT
Getpages Factor
The amount of standard deviations from the mean the getpages were at the time the exception was generated.
Offload table name
CQM_EXCEPTIONS
Column name
GETPGS_FACTOR
HV?
Indicates whether or not host variables have been collected for the activity.
Jobname
The name of the job.
Offload table name
CQM_EXCEPTIONS
Column name
JOBNAME
Log Bytes Written
The number of log bytes written.
Offload table name
CQM_EXCEPTIONS
Column name
LOG_BYTES_WRITTEN
Log Records Written
The total number of log records written.
Offload table name
CQM_EXCEPTIONS
Column name
LOG_RECORDS_WRITTEN
LUName
The logical unit name.
Offload table name
CQM_EXCEPTIONS
Column name
LUNAME
Netid
The network identifier.
Offload table name
CQM_EXCEPTIONS
Column name
NETID
Orig Token
The thread token assigned to the thread that generated the parallel task(s) on the parallelism coordinator Db2 subsystem.
Offload table name
CQM_EXCEPTIONS
Column name
ORIGNINATING_TOKEN
Package Version
The package version associated with the SQL statement.
Offload table name
CQM_EXCEPTIONS
Column name
PROGRAM_VERSION
Parallel
Indicates whether or not the SQL activity was formulated using Db2 query parallelism.
Offload table name
CQM_EXCEPTIONS
Column name
PARALLEL
Plan
The plan name.
Offload table name
CQM_EXCEPTIONS
Column name
PLAN
Program
The Db2 package or DBRM name.
Offload table name
CQM_EXCEPTIONS
Column name
PROGRAM
Req Site
The requesting site name.
Offload table name
CQM_EXCEPTIONS
Column name
REQ_SITE_NAME
RollAvg CPU
The value of the CPU rolling average at the time the exception was generated.
Offload table name
CQM_EXCEPTIONS
Column name
CPU_ROLL_AVG
RollAvg Elapsed
The value of the elapsed time rolling average at the time the exception was generated.
Offload table name
CQM_EXCEPTIONS
Column name
ELAP_ROLL_AVG
RollAvg Getpages
The value of the getpage rolling average at the time the exception was generated.
Offload table name
CQM_EXCEPTIONS
Column name
GETPGS_ROLL_AVG
Section
The section number.
Offload table name
CQM_EXCEPTIONS
Column name
SECTION
SP Creator
The creator of the stored procedure.
Offload table name
CQM_EXCEPTIONS
Column name
SP_CREATOR
SP Name
The name of the stored procedure.
Offload table name
CQM_EXCEPTIONS
Column name
SP_NAME
SQL Calls
The total number of individual SQL calls executed by Db2.
Offload table name
CQM_EXCEPTIONS
Column name
SQL_CALLS
Sqlcode
The SQL return code issued by Db2.
Offload table name
CQM_EXCEPTIONS
Column name
SQLCODE
Start Time
The date and time that an individual SQL statement started executing its first SQL call.
Offload table name
CQM_EXCEPTIONS
Column name
START_TIME
StdDev CPU
The value of the CPU rolling standard deviation at the time the exception was generated.
Offload table name
CQM_EXCEPTIONS
Column name
CPU_ROLL_STDV
StdDev Elapsed
The value of the elapsed time rolling standard deviation at the time the exception was generated.
Offload table name
CQM_EXCEPTIONS
Column name
ELAP_ROLL_STDV
StdDev Getpages
The value of the getpages rolling standard deviation at the time the exception was generated.
Offload table name
CQM_EXCEPTIONS
Column name
GETPGS_ROLL_STDV
Token
The thread token. A thread token uniquely identifies an individual connection to a Db2 subsystem.
Offload table name
CQM_EXCEPTIONS
Column name
THREAD_TOKEN
Workload
The name of the SQL workload. The workload name is a 32-byte character string that is assigned to the SQL activity by the selection criteria of the profile line and identifies the SQL activity in current activity, exceptions, and alerts. It is recommended that you name your workload to facilitate the identification of the monitoring profile line and the workload with which captured activity is associated.
Offload table name
CQM_EXCEPTIONS
Column name
WORKLOAD_NAME
WS Name
The workstation name.
Offload table name
CQM_EXCEPTIONS
Column name
WORKSTATION_NAME
WS Tran
The workstation transaction.
Offload table name
CQM_EXCEPTIONS
Column name
WORKSTATION_TRAN
WS User
The workstation user.
Offload table name
CQM_EXCEPTIONS
Column name
WORKSTATION_USER
zIIP CPU
The amount of CPU time accumulated while executing in Db2 on a zIIP processor.
Offload table name
CQM_EXCEPTIONS
Column name
ZIIP_CPU_TIME