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

Querying SQL/MX Metadata
HP NonStop SQL/MX Installation and Management Guide—544536-007
8-16
Locating System Defaults Schema Tables
•
In this example, the physical Guardian name of the SYSTEM_DEFAULTS table is
\FIGARO.$DATA08.ZSDA76D1.WF39P500:
showlabel
nonstop_sqlmx_node.system_defaults_schema.system_defaults;
=============================================================
GuardianName: \FIGARO.$DATA08.ZSDA76D1.WF39P500
AnsiName:
NONSTOP_SQLMX_FIGARO.SYSTEM_DEFAULTS_SCHEMA.SYSTEM_DEFAULTS
AnsiNameSpace: TA
ObjectSchemaVersion: 1200
ObjectFeatureVersion: 1200
Owner: SUPER.SUPER
RedefTimestamp: 26 Mar, 2004 10:08:06 (211947084486226458)
CreationTimeStamp: 26 Mar, 2004 10:08:49 (211947084529627935)
LastModTimestamp: 26 Mar, 2004 12:50:38 (211947094238951019)
LastOpenTimeStamp: 30 Mar, 2004 15:03:36 (211947447816966052)
SMDtable: F
File Organization: Key-sequenced
Block Length: 4096
File Code: 563
AuditCompress: T
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: 128 Pages
Secondary Extent Size: 256 Pages
Max Extents: 512
Extents Allocated: 1
EOF: 12288
Index Levels: 2