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

Querying SQL/MX Metadata
HP NonStop SQL/MX Installation and Management Guide—523723-004
8-18
Locating System Defaults Schema Tables
•
This is an example from the OSS prompt:
# cat /G/system/zsqlmx/mxanchor
SQLMX_MetaData_Loc=$data08
# ls /G/data08/zsd0
alluid00 catsys00 schrep00
alluid01 catsys01 schrep01
catref00 schema00
catref01 schema01
# mxtool info \$data08.zsd0.alluid00
NonStop SQL/MX MXTOOL Utility 2.0
(c) Copyright 2003 Hewlett-Packard Development Company, LP.
All Rights Reserved.
File Name: \FIGARO.$DATA08.ZSD0.ALLUID00
Object Schema Version: 1200
Ansi Name: NONSTOP_SQLMX_FIGARO.SYSTEM_SCHEMA.ALL_UIDS
Ansi NameSpace: TA
Locating System Defaults Schema Tables
On a local node, the anchor file $SYSTEM.ZSQLMX.MXANCHOR contains a pointer to
the location of the system catalog. Every system catalog contains a special schema
called the SYSTEM_DEFAULTS_SCHEMA, which contains the SYSTEM_DEFAULTS
table. The associated Guardian file name for the SYSTEM_DEFAULTS table is
randomly generated; it is not preassigned like tables in the SYSTEM_SCHEMA.
Use the SHOWLABEL command to locate the SYSTEM_DEFAULTS table.
•
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)