IFCID 359 - Index Page Split

Edit online

This topic shows detailed information about Record Trace - IFCID 359 - Index Page Split.

IFCID 359 records information about index page splits. This record is written when performance trace class 4 is active.

Record trace - IFCID 359 - Index Page Split

The field labels shown in the following sample layout of Record Trace - IFCID 359 - Index Page Split are described in the following section. 

DATABASE ID:           DB123456      INDEX PAGE SET ID:    ID123456  PARTITION NUMBER: 12345
SPLITTING PAGE NUMBER: 1234567890    FLAGS:                x'c'
TIMESTAMP BEGIN:       11:22:33.0000 TIMESTAMP END:        12:12:12.0000
DATABASE ID

The database ID of the splitting index.

Field Name: QW0359DB

INDEX PAGE SET ID

The page set ID of the splitting index.

Field Name: QW0359OB

PARTITION NUMBER

The partition number of the splitting index.

Field Name: QW0359PT

SPLITTING PAGE NUMBER

The page number of the splitting index.

Field Name: QW0359PG

FLAGS

Shows if the index depends on the group buffer pool (GBP).

Field Name: QW0359FL

TIMESTAMP BEGIN

The time stamp when index splitting started.

Field Name: QW0359TS

TIMESTAMP END

The time stamp when index splitting stopped.

Field Name: QW0359TE