Record Headers

Records written in a record trace report are prefixed by a header. The header is rewritten if any of the header information changes.


PRIMAUTH CONNECT   INSTANCE      END_USER       WS_NAME                       TRANSACT
ORIGAUTH CORRNAME  CONNTYPE      RECORD TIME    DESTNO ACE IFC  DESCRIPTION   DATA
PLANNAME CORRNMBR                TCB CPU TIME              ID
-------- -------- ----------- ----------------- ------ --- --- -------------- ------------------------------------------------------
SOF      BATCH    B1BAA2A382C5 'ANDREW          'ANDREWS_PC'                  'BLANK'
SOF      ZSQLASA1 TSO         23:48:01.86220375     41   1   3 ACCOUNTING     NETWORKID:  Y61Y      LUNAME:  STM4Y61Y  LUWSEQ:     1
POCDRIV7 'BLANK'              N/P
--------------------------------------------------------------------------------------------------------------------------------------

Field description

The following information is reported in the trace header:

PRIMAUTH: The authorization ID under which the transaction is running. Derived from the DB2® field QWHCAID.
ORIGAUTH: The original authorization ID under which the transaction started. Derived from the DB2 field QWHCOPID.
PLANNAME: The DB2 plan name. Derived from the DB2 field QWHCPLAN.
CONNECT: The connection ID. Derived from the DB2 field QWHCCN.
CORRNAME: The correlation name. Derived from the DB2 field QWHCCV.
CORRNMBR: The correlation number. Derived from the DB2 field QWHCCV.
INSTANCE: The unique number assigned to a thread. Derived from the DB2 field QWHSLUUV.
CONNTYPE: The type of connection being used to interface with DB2. Derived from the DB2 field QWHATYP.
END_USER: User ID of the workstation end user. Derived from the DB2 field QWHCEUID.
RECORD TIME: The timestamp contained in the trace record. The format is hours, minutes, seconds, and hundred-millionths of a second. Derived from the DB2 field QWHSSTCK.
TCB CPU TIME: The CPU time stored in the trace record. The format is minutes, seconds, and hundred-millionths of a second. Derived from the DB2 field QWHUCPU.
WS_NAME: Name of the workstation. Derived from the DB2 field QWHCEUWN.
DEST SEQ NO: The destination sequence number. Derived from the DB2 field QWHSWSEQ.
ACE: The relative number of the agent control element address in the ACE cross-reference table. This table is printed at the end of each location for every trace specified. Derived from the DB2 field QWHSACE.
IFCID: The instrumentation facility component identification (DB2 trace record type). Derived from the DB2 field QWHSIID.
DESCRIPTION: A brief description of the IFCID record. The description indicates whether the record contains accounting, statistics, or performance data. For performance data, the description also indicates the event.
TRANSACT: Name of the workstation transaction. Derived from the DB2 field QWHCEUTX.
DATA: The data is printed in the standard hexadecimal dump format. The character format is on the right.