SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Measuring Performance
HP NonStop SQL/MX Installation and Management Guide—523723-004
15-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. You do not need the
DETAIL option to display Guardian or ANSI names:
SHOWLABEL SAMDBCAT.SALES.EMPLOYEE, DETAIL;
================================================================
GuardianName: \KINGPIN.$TX0101.ZSDFM5XP.TLWHJQ00
AnsiName: SAMDBCAT.PERSNL.EMPLOYEE
AnsiNameSpace: TA
ObjectSchemaVersion: 1200
ObjectFeatureVersion: 1200
Owner: SUPER.SUPER
RedefTimestamp: 10 Oct, 2003 13:07:58 ( 211932576478894108 )
CreationTimeStamp: 10 Oct, 2003 13:07:56 ( 211932576476130392 )
LastModTimestamp: 10 Oct, 2003 13:08:27 ( 211932576507638248 )
LastOpenTimeStamp: 11 Dec, 2003 17:50:39 ( 211937953839665672 )
SecurityTimestamp: 28 Oct, 2003 10:17:05 ( 211934125025098496 )
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
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