IFCID 006 - Read I/O Start

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

DBID: 6        POOL ID:          0     ACE:          2
OBID: 112      FIRST  : X'000000' READTYPE: D         
PAGE NUMBERING  : ABS   PARTITION NUMBER  :          0
TABLE_SPACE_TYPE: X'00' ZHYPERLINK REQUEST: N 

DBID

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.

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

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.

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

ZHYPERLINK REQUEST

Indicates whether or not the I/O is using zHyperLink (synchronous) I/O. Valid values are:

Y

The I/O is using zHyperLink (synchronous) I/O.

N

The I/O did not use zHyperLink (synchronous) I/O.

Field Name: QW0006SI