Example of the Exception Log
This topic provides an example of an 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 IBM OMEGAMON FOR DB2 PERFORMANCE EXPERT (V5R5M0) 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
The following sections describe the header and the fields in the Exception Log.