SQL/MX 2.x Reference Manual (H06.04+)

MXCI Commands
HP NonStop SQL/MX Reference Manual—540440-003
4-86
Examples of SHOWLABEL
failed)
CrashLabel: F
CrashOpen: F
IncompletePartBoundChg: F (If T, a Utility operation is in
progress or has failed)
RedoNeeded: F
RollfwdNeeded: F
UndoNeeded: F
UnreclaimedSpace: F (If T, a Utility operation is in progress
or has failed)
Primary Extent Size: 16 Pages
Secondary Extent Size: 64 Pages
Max Extents: 160
Extents Allocated: 0
EOF: 0
Index Levels: 0
Record Expression Label Length: 9168
Security Label Length: 120
Key Columns: 0 ASC
Partitioning Scheme: RP
Partition Array - 3 partition[s]
Partition[0]: \CARNAG.$CHINA.ZSDQHSJZ.RGCX9K00
Low Key: ( -2147483648 )
Partition[1]: \CARNAG.$KEMPO.ZSDQHSJZ.N9HX9K00
Low Key: ( 20 )
Partition[2]: \CARNAG.$LORI.ZSDQHSJZ.HMNX9K00
Low Key: ( 40 )
IndexMap Array - 2 index[es]
Index[0]: \CARNAG.$BLANCA.ZSDQHSJZ.JH8TCM00
Index columns: 1 ASC , 0 ASC
Index[1]: \CARNAG.$BLANCA.ZSDQHSJZ.W7DJ2M00
Index columns: 0 ASC , 1 ASC , 0 ASC
Trigger Status Array - 2 trigger[s]
Trigger[0]: trigger created (ID): 211944875578177762
Status: ENABLED
Trigger[1]: trigger created (ID): 211944875658652063
Status: ENABLED
=============================================================
--- SQL operation complete.