Standard report header

Each report, except the end-of-job report, begins with the standard report header.

Fields

Begin program-specific programming interface information.The standard report header has the following fields:
PRIMAUTH
The authorization ID under which the transaction is running.
Field Name: QWHCAID
ORIGAUTH
The original authorization ID under which the transaction started.
Field Name: QWHCOPID
PLANNAME
The Db2 plan name.
Field Name: QWHCPLAN
CONNECT
The connection ID.
Field Name: QWHCCN
CORRNAME
The correlation name.
Field Name: QWHCCV
CORRNMBR
The correlation number.
Field Name: QWHCCV
INSTANCE
The unique number that is assigned to a thread.
Field Name: QWHSLUUV
CONNTYPE
The type of connection that is being used to interface with Db2.
Field Name: QWHATYP
END_USER
The user ID of the workstation user.
Field Name: QWHCEUID
RECORD TIME
The timestamp that is contained in the trace record. The format is hours, minutes, seconds, and hundred-millionths of a second.
Field Name: QWHSSTCK
TCB CPU TIME
The CPU time that is stored in the trace record. The format is minutes, seconds, and hundred- millionths of a second.
Field Name: QWHUCPU
WS_NAME
The name of the workstation.
Field Name: QWHCEUWN
DESTNO
The destination sequence number.
Field Name: QWHSWSEQ
IFCID
The instrumentation facility component identification (Db2 trace record type).
Field Name: 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
The name of the workstation transaction.
Field Name: QWHCEUTX

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'           
End program-specific programming interface information.