IFCID 015 - Index Scan Begin

This topic shows detailed information about Record Trace - IFCID 015 - Index Scan Begin.

Record trace - IFCID 015 - Index Scan Begin

The field labels shown in the following sample layout of Record Trace - IFCID 015 - Index Scan Begin are described in the following section.


DBID    DSNDB06   REC ID          37  CUB  00F348C5
OBID    DSNDSX01  INDX ID          5
COLUMN1   OPER      COL/VAL          CONN   TRUE/FALSE
10    NE  4000000000000000      A    'NONE'
15    NE  4000000000000000 'NONE'    'NONE'

DBID

The database ID. Deduced from the Db2 fields QW0015DB, QW0105DN or QW0107DN.

When present, the database name is shown, otherwise the decimal identifier from QW0015DB is shown, or N/A when this value is 0.

Field Name: RT0015DB

REC ID

The decimal identifier of the Db2 table OBID.

Field Name: QW0015OB

CUB

The hexadecimal address of the CUB token.

Field Name: QW0015AC

OBID

The object ID. Deduced from the Db2 fields QW0015OB, QW0105TN or QW0107TN.

When present, the name of the object is shown, otherwise the decimal identifier from QW0015OB is shown, or N/A when this value is 0.

Field Name: RT0015OB

INDX ID

The index identifier.

Field Name: QW0015IB

COLUMN1

The first column number.

Field Name: QW0015C1

OPER

The logical operator:

NE: Not equal to
GT: Greater than
GE: Greater than or equal to
LE: Less than or equal to
E: Equal
L: Less than
LT: Less than
LI: Like
NL: Not like
??: Unknown operator

Field Name: QW0015OP

COL/VAL

Column data is printed in decimal. Value data is printed in hexadecimal.

Field Name: QW0015VA

CONN

The connector value:

A: And
O: Or
NONE: Not specified

Field Name: QW0015CO

TRUE/FALSE

Indicates whether the comparison is true:

T: True
F: False
NONE: Not specified

Field Name: QW0015TF