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    1         RETCODE          0  ACE           1
OBID    9         READ             7                  
PAGE NUMBERING: N/A      PARTITION NUMBER:          0 
PAGE PREFETCHED VIA IO OPERATION:                     
  X'00000026' X'00000027' X'00000028' X'00000029'     
  X'0000002A' X'0000002B' X'0000002C'

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

PAGE PREFETCHED VIA IO OPERATION

Start of change The page number that was prefetched during an I/O operation. End of change

Field Name: QW0007PF

Feedback