SQL/MX 3.2.1 Management Manual (H06.26+, J06.15+)

Use the SHOWLABEL command to locate the SYSTEM_DEFAULTS table.
• 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 or has failed)
Primary Extent Size: 128 Pages
Secondary Extent Size: 256 Pages
Max Extents: 512
Extents Allocated: 1
EOF: 32768
Index Levels: 1
• In the following example on a node called \DMR15, a SELECT statement to access information
from the PARTITIONS, OBJECTS, SCHEMATA, and CATSYS tables to display volume and
subvolume of the SYSTEM_DEFAULTS table is used. Then it uses the ls command on that volume
and subvolume to get a list of the default schema table names. The additional files in the
subvolume $DATA08.ZSDA984F are the user metadata tables that contain histogram
information.
# mxci
Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 3.1
(c) Copyright 2003, 2004-2011 Hewlett-Packard Development Company, LP.
>> set schema
nonstop_sqlmx_dmr15.definition_schema_version_3100;
Displaying System Schema Information 115