IFCID 017 - Sequential Scan Begin

This topic shows detailed information about Record Trace - IFCID 017 - Sequential Scan Begin.

Record trace - IFCID 017 - Sequential Scan Begin

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


DBID DSNDB06      REC ID           42
OBID SYSDBAUT
CUB  X'7D450BB8'    TYPE       N/A
COL1   OP      COL/VAL           CONN    T/F    ST
5  E   X'810E000000000000'  'NONE'  'NONE'

DBID

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

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

Field Name: RT0017DB

REC ID

The decimal identifier of the Db2 table OBID.

Field Name: QW0017OB

CUB

The hexadecimal address of the CUB token.

Field Name: QW0017AC

OBID

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

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

Field Name: RT0017OB

SCAN TYPE

Possible values are:

SQ: Sequential scan.
WF: Work-file scan.
TT: Temporary table scan.
TR: Transition table scan for a trigger.

Field Name: QW0017TY

COL1

The first column number.

Field Name: QW0017C1

OP

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: QW0017OP

COL/VAL

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

Field Name: QW0017VA

CONN

The connector type:

A: And
O: Or
NONE: Not specified

Field Name: QW0017CO

TRUE/FALSE

Indicates whether the comparison is true:

T: True
F: False
NONE: Not specified

Field Name: QW0017TF