IFCID 227 - Page Latch Contention End

This topic shows detailed information about Record Trace - IFCID 227 - Page Latch Contention End.

This IFCID records the end of an agent suspend wait for a page latch that was currently held by another agent.

DBID: DSNDB07   PSID: DSN4K00                         
PAGE NUMBER: X'000001'    CANCEL STATUS:  N           
PARTITION:      1       PAGE NUMBERING: ABS
ACE TOKEN:   1         TABLE_SPACE_TYPE:  N           

DBID

The database ID. Deduced from the Db2 fields QW0227DB, QW0105DN or QW0107DN.

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

Field Name: RT0227DB

PSID

The page set object identifier. When present this is the page set object name, otherwise it is the decimal identifier from QW0227OB.

Field Name: RT0227OB

PAGE NUMBER

The number of the page being read or written. If the value in TABLE_SPACE_TYPE is L or V, the page number covers 4 bytes instead of 3.

Field Name: QW0227PN

CANCEL STATUS

Indicates whether the latch requester was canceled.

Field Name: QW0227F

PARTITION

Shows the partition number or 0 if non-partitioned.

Field Name: QW0227PT

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

ACE TOKEN

The agent control element token of the requester.

Field Name: QW0227AC

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