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

Querying SQL/MX Metadata
HP NonStop SQL/MX Release 3.1 Installation and Management Guide—663852-001
8-18
Locating System Defaults Schema Tables

In this example, for a node called \DMR15, the physical Guardian name of the
SYSTEM_DEFAULTS table is
$ DATA02.ZSD5VXWZ.M26FB700:
showlabel
nonstop_sqlmx_dmr15.system_defaults_schema.system_defaults;
=============================================================
GuardianName: \DMR15.$DATA02.ZSD5VXWZ.M26FB700
AnsiName:
NONSTOP_SQLMX_DMR15.SYSTEM_DEFAULTS_SCHEMA.SYSTEM_DEFAULTS
AnsiNameSpace: TA
ObjectSchemaVersion: 3000
ObjectFeatureVersion: 1200
Owner: SUPER.SUPER
RedefTimestamp: 27 Nov, 2009 19:40:05 ( 212126091005566063
)
CreationTimeStamp: 27 Nov, 2009 19:40:17 ( 212126091017586769
)
LastModTimestamp: 19 Jan, 2011 16:35:46 ( 212162195146818505
)
LastOpenTimeStamp: 28 Jan, 2011 11:38:12 ( 212162954892302515
)
SMDtable: F
File Organization: Key-sequenced
Block Length: 4096
File Code: 563
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