IFCID 396 - Index Split Information

This topic shows detailed information about Record Trace - IFCID 396 - Index Split Information.

IFCID396 is a trace record for detail index split information when current index split process is considered as abnormal (elapsed time of index split is > a threshold). IFCID 396 is always enabled/opened by default under class 3 and performance class 6.

Record Trace - IFCID 396 - Index Split Information

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


|                                                INDEX SPLIT INFORMATION
|
|DATABASE ID       :   FALCDB01   PAGE NUMBER       :                    667149
|PAGE SET ID       :   PKRUIXRO   URID              :   X'000000000C4D422F7B5D'
|DATA SHR MEMBER ID:          1   TOTAL ELAPSED TIME:              21:39.189856
|PARTITION NUMBER  :          1   CURRENT TIME STAMP:  11/29/17 21:35:46.815024
|GBP DEPENDENT     :        YES

DATABASE ID

Database ID of current splitting index.

Field Name: QW0396DBID

PAGE SET ID

Page set ID of current splitting index.

Field Name: QW0396PSID

DATA SHR MEMBER ID

Data sharing member ID of current splitting index. 0 means non-data sharing.

Field Name: QW0396MEMID

PARTITION NUMBER

Partition number of current splitting index.

Field Name: QW0396PARTNUM

GBP DEPENDENT

Whether current index page set is marked as GBP dependent. 'Y' = GBP dependent.

Field Name: QW0396GBPD

PAGE NUMBER

Current splitting page number.

Field Name: QW0396PAGENUM

URID

UR ID related with current splitting index.

Field Name: QW0396URID

TOTAL ELAPSED TIME

Total elapse time of current abnormal index split. Unit is millisecond.

Field Name: QW0396ELAPSETIME

CURRENT TIME STAMP

Current timestamp of IFCID 396 generation.

Field Name: QW0396TIMESTAMP