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

MXCI Commands
HP NonStop SQL/MX Reference Manual—540440-003
4-85
Examples of SHOWLABEL
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
=============================================================
•
Use the SHOWLABEL, DETAIL command with a physical location (Guardian)
name:
>>showlabel \CARNAG.$CHINA.ZSDQHSJZ.RGCX9K00, detail;
=============================================================
GuardianName: \CARNAG.$CHINA.ZSDQHSJZ.RGCX9K00
AnsiName: MOD107.SCH.TAB1
AnsiNameSpace: TA
ObjectSchemaVersion: 1200
ObjectFeatureVersion: 1200
Owner: QADEV.TEG
RedefTimestamp: 29 Feb, 2004 20:34:18 ( 211944875658652063
)
CreationTimeStamp: 29 Feb, 2004 20:31:24 ( 211944875484237505
)
LastModTimestamp: 29 Feb, 2004 20:31:24 ( 211944875484237505
)
LastOpenTimeStamp: NEVER OPENED
SecurityTimestamp: 29 Feb, 2004 20:31:24 ( 211944875484152346
)
SMDtable: F
File Organization: Key-sequenced
Block Length: 4096
File Code: 550
AuditCompress: T
Audited: T (If F, a Utility operation is in progress or has
failed)
Broken: F
Buffered: T
ClearOnPurge: F
Corrupt: F (If T, a Utility operation is in progress or has