IFCID 007 - Read I/O Stop

This topic shows detailed information about Record Trace - IFCID 007 - Read I/O Stop.

Record trace - IFCID 007 - Read I/O Stop

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

DBID: 6        RETCODE:          0     ACE:          3
OBID: 2014     READ   :         32                    
PAGE NUMBERING  : ABS   PARTITION NUMBER  :          1
DASD CACHE HIT  : N     ZHYPERLINK REQUEST: Y         
PAGE PREFETCHED VIA IO OPERATION:                     
  X'00000040' X'00000041' X'00000042' X'00000043'     
  X'00000044' X'00000045' X'00000046' X'00000047'     
  X'00000048' X'00000049' X'0000004A' X'0000004B'     
  X'0000004C' X'0000004D' X'0000004E' X'0000004F'     
  X'00000050' X'00000051' X'00000052' X'00000053'     
  X'00000054' X'00000055' X'00000056' X'00000057'     
  X'00000058' X'00000059' X'0000005A' X'0000005B'     
  X'0000005C' X'0000005D' X'0000005E' X'0000005F'

DBID

The database ID. This is deduced from the Db2 fields QW0007DB, QW0105DN or QW0107DN.

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

Field Name: RT0007DB

RETCODE

The return code from the media manager.

Field Name: QW0007MM

ACE

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

OBID

The object ID. This is deduced from the Db2 fields QW0007OB, QW0105TN or QW0107TN.

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

Field Name: RT0007OB

READ

The number of pages read.

Field Name: QW0007NP

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

PARTITION NUMBER

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

Field Name: QW0007PT

DASD CACHE HIT

Indicates whether the I/O resulted in a disk subsystem cache hit or not. Valid values are:

Y: The requested data was found in the DASD subsystem cache.
N: The requested data was not found in the DASD subsystem cache.

Field Name: QW0007DC

ZHYPERLINK REQUEST

Indicates whether the I/O was synchronous or not. 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: QW0007SI

PAGE PREFETCHED VIA IO OPERATION

The page number that was prefetched during an I/O operation.

Field Name: QW0007PF