Example of the Exception Log

Exception Log - example

The header and fields shown in the example of the Exception Log are described in the following sections.

   LOCATION: LOCA1_LAB                  OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0)                   PAGE: 1-1
      GROUP: N/P                                        EXCEPTION LOG
     MEMBER: N/P
  SUBSYSTEM: DB1G                                                                                  ACTUAL FROM: 06/30/15
20:34:09.92
DB2 VERSION: V10                                                                                     PAGE DATE: 06/30/15


PRIMAUTH CONNECT  EXCEPTION TIME   PER                                                               CALCULATED          THRESHOLD
ORIGAUTH CORRNAME INSTANCE              FIELD ID FIELD DESCRIPTION                            BY         OR      OP   VALUE     TYPE
PLANNAME CORRNMBR CONNTYPE                                                                           FIELD VALUE
-------- -------- --------------- ----- -------- ----------------------------------------    ------ ------------ - ------------ ----
ADMF001  BATCH    20:34:09.925838 PLAN  ADCPUT   CPU TIME IN APPLICATION (CLASS 1)           TOTAL      0.328675 > 0            PROB
ADMF001  L282DML  X'A981C569657F'       ADRECETT ELAPSED TIME IN APPLICATION (CLASS 1)       TOTAL      3.613503 > 0            PROB
DSNTEP3  'BLANK'  TSO                   ADTDDL   TOTAL SQL DDL STATEMENTS                    TOTAL             0 < 1            WARN
MAINPACK:DSNTEP3                        ADTOTPFL TOTAL PARALL.GROUPS FELL TO SEQUENTIAL      TOTAL             0 < 1            WARN
                                        ADTWTAP  TOTAL WAIT TIME IN APPLICATION (CLASS 1)    TOTAL      3.284828 > 0            PROB
                                        ALCLKET  TOTAL LOCK ESCALATIONS                      TOTAL             0 < 1            WARN
                                        ALLPSUSP TOTAL ALL SUSPENSIONS (LOCAL AND GLOBAL)    TOTAL             0 < 1            WARN
                                        ALRSUSP  TOTAL ALL SUSPENSIONS                       TOTAL             0 < 1            WARN
                                        ARTTERM  RID LIST TERMINATED - ANY REASON            TOTAL             0 < 1            WARN
                                        ASCDCL   TOTAL SQL DCL STATEMENTS                    TOTAL             1 > 0            PROB
                                        ASCDML   TOTAL SQL DML STATEMENTS                    TOTAL            27 > 0            PROB
                                        ASIUD    TOTAL INSERTS, UPDATES AND DELETES          TOTAL             0 < 1            WARN
                                        QTXACLUN CLAIM REQUESTS UNSUCCESSFUL                 TOTAL             0 < 1            WARN
                                        QTXADEA  DEADLOCKS                                   TOTAL             0 < 1            WARN
                                        QTXADRUN DRAIN REQUESTS UNSUCCESSFUL                 TOTAL             0 < 1            WARN
                                        QTXALES  LOCK ESCALATIONS - SHARED                   TOTAL             0 < 1            WARN
                                        QTXALEX  LOCK ESCALATIONS - EXCLUSIVE                TOTAL             0 < 1            WARN
                                        QTXANPL  MAXIMUM PAGE LOCKS HELD                     TOTAL             7 > 0            PROB
                                        QTXASLOC LOCK SUSPENSIONS                            TOTAL             0 < 1            WARN
                                        QTXATIM  TIMEOUTS                                    TOTAL             0 < 1            WARN
                                        QWACABRT ROLLBACKS                                   TOTAL             0 < 1            WARN
                                        QWACCOMM COMMITS                                     TOTAL             1 > 0            PROB
                                        QXCALLAB STORED PROCEDURE ABENDS                     TOTAL             0 < 1            WARN
                                        QXCALLRJ CALL STATEMENT REJECTS                      TOTAL             0 < 1            WARN
                                        QXCALLTO CALL STATEMENT TIMEOUTS                     TOTAL             0 < 1            WARN
                                        QXDEGBUF PARALL.GROUPS FELL TO SEQ-NO BUFFER         TOTAL             0 < 1            WARN
                                        QXDEGCUR PARALL.GROUPS FELL TO SEQ-CURSOR UPD/DEL    TOTAL             0 < 1            WARN
                                        QXDEGESA PARALL.GROUPS FELL TO SEQ-NO ESA SORT       TOTAL             0 < 1            WARN
                                        QXINCRB  INCREMENTAL BINDS                           TOTAL             0 < 1            WARN
                                        QXMAXDEG MAX DEGREE OF I/O PARALLELISM               TOTAL             3 > 0            PROB
                                        QXMRMIAP RID LIST TERMINATED - MAXIMUM LIMIT         TOTAL             0 < 1            WARN
                                        QXNSMIAP RID LIST TERMINATED - NO STORAGE            TOTAL             0 < 1            WARN
                                        QXREDGRP PARALL.GROUPS RUN WITH REDUCED DEGREE       TOTAL             0 < 1            WARN
                                        ABCLSPR  BP0 TOTAL PREFETCH REQUESTS                 TOTAL             0 < 1            WARN
                                        QBACGET  BP0 GETPAGES                                TOTAL            33 > 0            PROB
                                        QBACIMW  BP0 SYNCHRONOUS WRITES                      TOTAL             0 < 1            WARN
                                        QBACRIO  BP0 SYNCHRONOUS READS                       TOTAL             0 < 1            WARN

EXCEPTION LOG COMPLETE