SQL/MX 3.1 Installation and Management Guide (H06.23+, J06.12+)

Measuring Performance
HP NonStop SQL/MX Release 3.1 Installation and Management Guide—663852-001
14-2
SHOWLABEL Command
SHOWLABEL Command
The MXCI SHOWLABEL command displays file-label information for SQL/MX objects.
(SHOWLABEL does not support SQL/MP objects or SQL/MP aliases.) For
performance statistics, use SHOWLABEL to determine index levels and extent
information.
This example returns detailed information about the EMPLOYEE table. Use the
DETAIL option to display information about partitions and indexes:
SHOWLABEL SAMDBCAT.PERSNL.EMPLOYEE, DETAIL;
================================================================
GuardianName: \DMR15.$SYSTEM.ZSDG5WVN.FVRZ1T00
AnsiName: SAMDBCAT.PERSNL.EMPLOYEE
AnsiNameSpace: TA
AnsiNameObjectType: BT
ObjectSchemaVersion: 3000
ObjectFeatureVersion: 1200
Owner: SUPER.SUPER
RedefTimestamp: 16 Dec, 2010 11:28:00 ( 212159239080672194 )
CreationTimeStamp: 16 Dec, 2010 11:27:57 ( 212159239077752342 )
LastModTimestamp: 16 Dec, 2010 11:28:18 ( 212159239098350394 )
LastOpenTimeStamp: 16 Dec, 2010 11:28:19 ( 212159239099574400 )
SecurityTimestamp: 16 Dec, 2010 11:27:57 ( 212159239077718742 )
SMDtable: F
File Organization: Key-sequenced
Block Length: 4096
File Code: 550
Row Format: PACKED FORMAT
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
failed)
CrashLabel: F
CrashOpen: F
IndexCompress: 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