IFCID 006 - Read I/O Start

This topic shows detailed information about "Record Trace - IFCID 006 - Read I/O Start".

Record trace - IFCID 006 - Read I/O Start

The field labels shown in the following sample layout of "Record Trace - IFCID 006 - Read I/O Start" are described in the following section.

DBID: TDKURDB   POOL ID:        100  ACE     :       1
OBID: TDKURTS1  FIRST: X'01000012'  READTYPE: R
PAGE NUMBERING: ABS                             
TABLE_SPACE_TYPE : V     PARTITION NUMBER:          1

DBID

Start of change The page set ID. This page set can be either a table space or an index space. If it is a table space, use this value to match column PSID in SYSIBM.SYSTABLESPACE to find the name of the table space. If it is an index space, use this value to match column ISOBID SYSIBM.SYSINDEXES to find the internal name of the index space. This is deduced from the DB2 fields QW0006OB, and QW0105TN or QW0107TN. End of change

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

Field Name: RT0006DB

POOL ID

The internal identifier of the buffer pool. The values 0 through 49 are the identifiers for BP0 through BP49. The values 80 through 89 are the identifiers for BP32K through BP32K9.

Field Name: QW0006BP

ACE

The agent control element (ACE) token of the requester.

The relative number of the agent control element address in the ACE cross-reference table. This table is printed at the end of each location for every trace specified.

Field Name: QW0006AC

OBID

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

Field Name: RT0006OB

FIRST

The hexadecimal number of the first page to be read for a table space that is not defined as large.

Field Name: QW0006PN

READTYPE

The type of read performed:

S: Sequential prefetch request
L: List prefetch request
D: Dynamic sequential prefetch request
R: Synchronous read request

Field Name: QW0006F

PAGE NUMBERING

Indicates how page numbers are shown for partitioned tables:

REL: Indicates that relative page numbers are shown in the partition.
ABS: Indicates that absolute page numbers are shown in the partition.
N/A: Not applicable.

Field Name: QW0006P1

TABLE_SPACE_TYPE

The type of the table space:

L: Non-EA large table
N: Non-large table
V: EA-enabled large table

Field Name: QW0006FG

PARTITION NUMBER

The partition number. This value is 0 if the table space is not partitioned.

Field Name: QW0006PT

Feedback