Standard report header
Each report, except the end-of-job report, begins with the standard report header.
Fields
- PRIMAUTH
- The authorization ID under which the transaction is running.
- ORIGAUTH
- The original authorization ID under which the transaction started.
- PLANNAME
- The Db2 plan name.
- CONNECT
- The connection ID.
- CORRNAME
- The correlation name.
- CORRNMBR
- The correlation number.
- INSTANCE
- The unique number that is assigned to a thread.
- CONNTYPE
- The type of connection that is being used to interface with Db2.
- END_USER
- The user ID of the workstation user.
- RECORD TIME
- The timestamp that is contained in the trace record. The format is hours, minutes, seconds, and hundred-millionths of a second.
- TCB CPU TIME
- The CPU time that is stored in the trace record. The format is minutes, seconds, and hundred- millionths of a second.
- WS_NAME
- The name of the workstation.
- DESTNO
- The destination sequence number.
- IFCID
- The instrumentation facility component identification (Db2 trace record type).
- 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
- The name of the workstation transaction.
Example
PRIMAUTH CONNECT INSTANCE END_USER WS_NAME TRANSACT
ORIGAUTH CORRNAME CONNTYPE RECORD TIME DESTNO IFC DESCRIPTION DATA
PLANNAME CORRNMBR TCB CPU TIME ID
-------- -------- ------------ -------------------------- --- -------------- ---------------
SYSADM BATCH X'BFE0F0E22787'
SYSADM CCTRACE4 TSO 01:02:39 0000006030 003 DDF Data by Location
DSNBIND 'BLANK'