Field Descriptions

This topic describes the fields of an Exception Log.

The following fields are shown including OMEGAMON® for DB2® PE:

PRIMAUTH

The primary authorization ID of the thread.

ORIGAUTH

The original authorization ID of the thread.

PLANNAME

The DB2 application plan name of the thread.

CONNECT

The DB2 connection ID of the thread.

CORRNAME

The correlation name of the thread.

CORRNMBR

The correlation number of the thread.

EXCEPTION TIME

For accounting records, this is the accounting timestamp. For statistics records, this is the END TIME of the statistics interval in which the exception occurred.

INSTANCE

The LUW instance number.

CONNTYPE

The type of connection for the associated thread. Values are:

CICS

CICS® Attach

DB2 PRIV

DB2 private protocol

DB2CALL

DB2 CALL Attach

DLI-BTCH

DL/I Batch

DRDA

DRDA protocol

IMS-CNTL

IMS Control Region

IMS-BMP

IMS nontransaction-oriented BMP

IMS-MPP

IMS Attach MPP

IMS-TBMP

IMS transaction-oriented BMP

RRS

RRS attach

TSO

TSO foreground and background

UTILITY

Utility attach

If connection type is not present, 'BLANK' is printed.

MAINPACK

This identifier is used to distinguish plans according to the packages they contain.

PER

This identifies the log entry as an exception per system, per plan, or per program.

FIELD ID

The field ID of the accounting or statistics field in exception status.

FIELD DESCRIPTION

A description of the field in exception status. This description matches, as closely as possible, the terminology used in the Accounting and Statistics reports. If the field in exception status is a buffer pool field, the buffer pool ID is printed in front of the field description on the same line. Values are:

• BP0 — BP49
• BP32K — BP32K9

All nondistributed fields for an accounting thread or statistics interval are listed first. Any distributed fields in exception status follow the nondistributed fields and are grouped by remote location. Packages follow after DDF and are grouped by package name.

BY

The basis used for comparing values in the records to values in the exception threshold data set. Values are:

• TOTAL — an absolute value (the default)
• MINUTE — by minute
• SECOND — by second
• COMMIT — by commit
• THREAD — by thread

CALCULATED OR FIELD VALUE

The value from the field in exception status — either an absolute value or a value calculated according to the comparison basis.

Time values are reported in the format sssssss.thtt, where sssssss is time in seconds and thtt is in tenths, hundredths, thousandths, and ten-thousandths of seconds. Integer values such as aborts and selects are reported in the format nnnnnnnnnnnn. Other values are reported in the format nnnnnnnnn.nn.

OP

The greater than (>) or less than (<) operator.

THRESHOLD VALUE

The value defined in the exception threshold data set, above or below which the actual value must fall to be considered in exception status.

THRESHOLD TYPE

Describes whether the THRESHOLD VALUE is defined in the exception threshold data set as a WARNing or a PROBlem.