Record trace description
The following fields are printed in the header.
In cases where the header fields are missing because no correlation header exists or because the field does not exist in the relevant version of Db2, N/A is printed. The information described in the Field descriptions section are reported for every field displayed in the report.
Field | Description |
|---|---|
Header fields | |
IFCID | IFCID number and description for the selected record |
SID | System identifier that is used in SMF records This value is specified by your systems programmer in the SMFPRMxx member of PARMLIB by way of the SID parameter. The system identifier can be based on the z/OS system name or processor serial numbers. |
SSID | Subsystem ID and Db2 version number of the Db2 that produced the record |
IFC-Seq | Traced IFCID sequence number This value is derived from the Db2 field QWSCIID. |
Token | CICS logical unit of work ID (minus the commit count) This value is used to relate CICS records to their associated Db2 records. This value is derived from the Db2 field QWHTOKN. If the value in this field is blank or zero, N/A is printed. |
Time | Timestamp of the selected record in the following format: mm/dd/yy hh:mm:ss.ffffff
|
DestSeq | Destination sequence number This value is derived from the Db2 field QWHSWSEQ. |
ACE | Agent control element address of the thread This value is derived from the Db2 field QWHSACE. |
Loc Name | Location name of the Db2 subsystem that generated the record In a distributed environment, this name is unique among the Db2 subsystems that can communicate with each other. This field is derived from Db2 field QWHSLOCN. |
Req Loc | Location name of the Db2 subsystem where the distributed request originated If the local location and requesting location are the same, this thread is either an allied or a distributed allied thread. If the locations are different, this thread is a database access thread (DBAT). This field is derived from Db2 field QWHDRQNM. |
Req time | Timestamp from the requesting location when the server recognizes that the thread is a DBAT (database access thread on behalf of remote users) This field is derived from Db2 field QWHDTSTP. |
Auth | Db2 authorization ID that is used by the thread (or the exception list owner for IFCID BMC 246) This field is derived from Db2 field QWHCAID. |
Plan | Name of the Db2 plan that is used by the thread (or the exception list name for IFCID BMC 246) This field is derived from Db2 field QWHCPLAN. |
Corr | Correlation ID, which is used with the connection ID to identify the Db2 task (or the exception measure or formula name for IFCID BMC 246) This field is derived from Db2 field QWHCCV. |
Oper | Original value of the authorization ID before it is changed by any secondary authorization exits This field is derived from Db2 field QWHCOPID. |
Conn | Connection ID, which identifies the transaction environment Possible values are:
This field is derived from Db2 field QWHCCN. |
ConTyp | Type of connection that is used by the selected thread Possible values are:
This field is derived from Db2 field QWHCCST. |
Net ID | Network ID This value is used with the LUNAME and instance number to identify both the local and remote activity of a distributed transaction. This value is derived from Db2 field QWHSNID. |
LUNAME | Logical unit name This value is used with the network ID and instance number to identify both the local and remote activity of a distributed transaction. This value is derived from Db2 field QWHSLUNM. |
Instance | Instance number This value is used with the network ID and LUNAME to identify both the local and remote activity of a distributed transaction. All threads that are involved in the same distributed transaction share the same instance number. The instance number is printed in hexadecimal format. This value is derived from Db2 field QWHSLUUV. |
SRVNAM | Name of the application requester If the requester is another Db2 subsystem, this value is the same as the requesting location; otherwise the name that is used by the requester is printed. This value is derived from Db2 field QWHDSVNM. |
PRDID | Product ID of the requester This value is derived from Db2 field QWHDPRID. |
Commit Ct | Logical unit of work sequence number This value is derived from Db2 field QWHSLUCC. |
Data Sharing Group Name | Name of the data sharing group to which this Db2 belongs |
DB2 Member Name | Member name of this Db2 in the data sharing group |
Report fields | |
OFST | Offset (in hexadecimal format) of this field from the beginning of the DSECT in the selected record |
Field | Name of this field in the selected record |
T | Data type Possible values are:
|
LEN | Length (in hexadecimal format) of this field This is the length of the field within the record, not the length of the formatted output printed. |
Description | Description of the field |
Value | Value from this field in the selected record If the data type is B or H, the value is displayed in hexadecimal format. If the value is too large to be printed in the space that is provided, the space is filled with asterisks (***) followed by the words SEE BELOW. The value is printed on the following line starting from the extreme left. |
Related topic