IFCID 060 - Select Start

This topic shows detailed information about Record Trace - IFCID 060 - Select Start.

START         LOCATION NAME        : PMO5D851
PKG COLLECTION ID    : DB2PM
PROGRAM NAME         : DGO@PC1
CONSISTENCY TOKEN    : X'1747F0EF086D1D5E'
STATEMENT NUMBER     :        318
STATEMENT TYPE       : X'00'
QUERY COMMAND ID     : N/P
QUERY INSTANCE ID    : N/P
ISOLATION            : RR
REOPTIMIZATION       : NO

LOCATION NAME

The location name.

Field Name: QW0060LN

PKG COLLECTION ID

The package collection identifier.

Field Name: QW0060PC

PROGRAM NAME

The program name.

Field Name: QW0060PN

CONSISTENCY TOKEN

The consistency token.

Field Name: QW0060TS

STATEMENT NUMBER

The statement number of the statement executed.

Field Name: QW0060SN

STATEMENT TYPE

The statement type. X'00' indicates SELECT.

Field Name: QW0060ST

QUERY COMMAND ID

The ID of the query command.

Field Name: QW0060CID

QUERY INSTANCE ID

The ID of the query instance.

Field Name: QW0060QID

ISOLATION

The isolation level:

RR

Repeatable read

CS

Cursor stability

RS

Read stability

UR

Uncommitted read

Field Name: QW0060I

REOPTIMIZATION

Indicates whether the access path of the SQL statement was reoptimized at run time.

Field Name: QW0060RO