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