Exceptions - columns (ISPF)
These columns are available on the exceptions panel.
- 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 IBM Db2 Analytics Accelerator for z/OS.
- Acctg Token
- The accounting token.
- 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.
- 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.
- 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.
- 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). - ASQLCode
- The SQL code that raised an alert condition. Alert criteria are defined within a monitoring profile.
- Authid
- The primary authorization ID.
- 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).
- Child
- Indicates whether the exception is related to another (parent) exception.
- CPU Dsc
- Indicates whether or not the value of the CPU for a given SQL statement was not factored into the rolling mean and standard deviation.
- CPU DscT
- 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.
- CPU Factor
- The amount of standard deviations from the mean the CPU was at the time the exception was generated.
- Collection
- The collection ID.
- Connname
- The connection name.
- CONTOKEN
- The hexadecimal 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).
- Coordinator
- The DB2 subsystem name acting as the parallelism coordinator for a parallel task associated with the Db2 metrics data gathered by Db2 Query Monitor.
- Corrid
- The correlation ID.
- Corrname
- The correlation ID adjusted by the conventions used by IMS and CICS.
- Corrnum
- The correlation number which is set based on the default OMEGAMON® parsing of the CORRID value.
- Cursor Name
- The cursor name.
- DB2 CPU Time
- The accumulated total of all TCB and SRB CPU time spent executing in Db2.
- DB2 Elapsed
- The accumulated elapsed time while executing within Db2.
- Delay Time
- The total time spent waiting due to specific delay events.
- 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.
- 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.
- 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.
- Elap Dsc
- Indicates whether or not the value of the elapsed time for a given SQL statement was not factored into the rolling mean and standard deviation.
- Elap DscT
- 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.
- Elapsed Factor
- The amount of standard deviations from the mean the elapsed time was at the time the exception was generated.
- End Time
- The date and time that an individual SQL statement finished executing its last SQL call.
- ESQLCode
- The SQL code that raised an exception condition. Exception criteria are defined within a monitoring profile.
- 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
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). - 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.
- Getpages Dsc
- Indicates whether or not the value of the getpages for a given SQL statement was not factored into the rolling mean and standard deviation.
- Getpages DscT
- 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.
- Getpages Factor
-
The amount of standard deviations from the mean the getpages were at the time the exception was generated.
- HV?
- Indicates whether or not host variables have been collected.
- Jobname
- The name of the job.
- Log Bytes Written
- The number of log bytes written.
- Log Records Written
- The total number of log records written.
- LUName
- The logical unit name.
- Netid
- The network identifier.
- Orig Token
- The thread token assigned to the thread that generated the parallel task(s) on the parallelism coordinator Db2 subsystem.
- Package Version
- The package version associated with the SQL statement.
- Parallel
- Indicates whether or not the SQL activity was formulated using Db2 query parallelism.
- Plan
- The plan name.
- Program
- The Db2 package or DBRM name.
- Req Site
- The requesting site name.
- RollAv CPU
- The value of the CPU rolling average at the time the exception was generated.
- RollAv Elapsed
- The value of the elapsed time rolling average at the time the exception was generated.
- RollAv Getpages
- The value of the getpage rolling average at the time the exception was generated.
- Section
- The section number.
- SP Creat
- The creator of the stored procedure.
- SP Name
- The name of the stored procedure.
- SQL Calls
- The total number of individual SQL calls executed by Db2.
- Sqlcode
- The SQL return code issued by Db2.
- SSID
- The Db2 subsystem on which the activity occurred.
- Start Time
- The date and time that an individual SQL statement started executing its first SQL call.
- StdDev CPU
- The value of the CPU rolling standard deviation at the time the exception was generated.
- StdDev Elapsed
- The value of the elapsed time rolling standard deviation at the time the exception was generated.
- StdDev Getpages
- The value of the getpages rolling standard deviation at the time the exception was generated.
- Stmt#
- The SQL statement number assigned by the Db2 pre-compiler to an individual SQL call.
- Token
- The thread token. A thread token uniquely identifies an individual connection to a Db2 subsystem.
- 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.
- WS Name
- The workstation name.
- WS Tran
- The workstation transaction.
- WS User
- The workstation user.
- zIIP CPU
- The amount of CPU time accumulated while executing in Db2 on a zIIP processor.