IFCID 127 - Page Wait I/O In Prog (Start)

This topic shows detailed information about "Record Trace - IFCID 127 - Page Wait I/O In Prog (Start)".

Record trace - IFCID 127 - Page Wait I/O In Prog (Start)

The field labels shown in the following sample layout of "Record Trace - IFCID 127 - Page Wait I/O In Prog (Start)" are described in the following section.

DBID:           TDKURDB            PSID:      TDKURTS1
PAGE NUMBER:    X'00000000'   PAGE NUMBERING: ABS   
PARTITION:  1         TYPE OF I/O:      FORCE WRITE   
POOL ID:                 0          ACE:        1     
TABLE SPACE TYPE: L

DBID

The database ID. Deduced from the DB2 fields QW0127DB, QW0105DN or QW0107DN.

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

Field Name: RT0127DB

OBID / PSID

Start of change For classic segmented table spaces, this value shows the table OBID. For partitioned table spaces, it is the PSID of the table space. Deduced from the DB2 fields QW0127OB, QW0105TN, or QW0107TN. End of change

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

Field Name: RT0127OB

PAGE NUMBER

The number of the page being read or written.

Field Name: QW0127PN

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

PARTITION

Start of change Shows the partition number or 0 if non-partitioned. End of change

Field Name: QW0127PT

TYPE OF I/O

The type of I/O process.

Field Name: QW0127F

POOL ID

The buffer pool internal identifier. 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: QW0127BP

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

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

Feedback