IFCID 124 - SQL Statement Record

This topic shows detailed information about Record Trace - IFCID 124 - SQL Statement Record.

Record trace - IFCID 124 - SQL Statement Record

The field labels shown in the following sample layout of Record Trace - IFCID 124 - SQL Statement Record are described in the following section.


CONNECTION TYPE: 'BLANK'             ACE TOKEN   : X'1D702EB0'         THREAD ASID  : X'009E'   ASCB TOKEN  : X'00FBD280'
APPL REQ COUNT :    4193             AGENT NAME  : 'BLANK'             THREAD STATUS: IN DB2    TCB TOKEN :   X'008CCD90'
THREAD TYPE    : DATABASE ACCESS     AGENT TYPE  : 'BLANK'
STATEMENT TYPE : DYNAMIC             STATEMENT IDENTIFIER: X'12345678901234567890'
LOCATION : OMPDA61             COLLECTION: NULLID              PACKAGE: SYSSH200              TOKEN:  X'5359534C564C3031'
NETWORKID: G998CD1D            LUNAME: G773                    UNIQUENESS VALUE: X'C571F0AE3062'          LUWSEQ:     496
ENDUSER  : pioch               WSNAME: IBM-49AF7CD512F         TRANSACT:         perl.exe
QW01246L   X'00'

CONNECTION TYPE

The connection type. 'BLANK' indicates that there is no connection type.

Field Name: QW01246Y

ACE TOKEN

The ACE token in hexadecimal.

Field Name: QW01246A

THREAD ASID

The ASID of the thread in hexadecimal.

Field Name: QW01246S

ASCB TOKEN

The ASCB token in hexadecimal.

Field Name: QW01246C

APPL REQ COUNT

The number of calls to Db2 in decimal.

Field Name: QW01246Q

AGENT NAME

When an agent is running a stored procedure, trigger, or user-defined function, this is the unqualified name of the routine. Otherwise, this field is blank.

Field Name: QW0124SP

THREAD STATUS

The status of the thread.

Field Name: QW01246I

TCB TOKEN

The TCB token in hexadecimal.

Field Name: QW01246T

THREAD TYPE

The type of thread.

Field Name: QW01246D

AGENT TYPE

The type of the agent.

Field Name: QW0124AF

STATEMENT TYPE

The statement type.

Field Name: QW0124TK

STATEMENT IDENTIFIER

The statement ID (former Cached Dynamic SQL Identifier).

Field Name: QW0124ST

LOCATION

The name of the location where the thread executes the package.

Field Name: QW0124LN

COLLECTION

The collection name.

Field Name: QW0124CI

PACKAGE

The package identifier.

Field Name: QW0124PN

TOKEN

The consistency token.

Field Name: QW0124CN

NETWORKID

The network identifier.

Field Name: QW0124NI

LUNAME

The logical unit name.

Field Name: QW0124LM

UNIQUENESS VALUE

The instance number.

Field Name: QW0124UV

LUWSEQ

The LUW sequence number.

Field Name: QW0124CC

ENDUSER

The user ID at the end user's workstation.

Field Name: QW0124EI

WSNAME

The workstation name of the end user.

Field Name: QW0124EW

TRANSACT

The transaction name of the end user.

Field Name: QW0124ET