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-18
Locating MXCS Schema Tables
All Rights Reserved.
File Name: \FIGARO.$DATA08.ZSDA984F.FPJCX800
Object Schema Version: 1200
Ansi Name:
NONSTOP_SQLMX_FIGARO.SYSTEM_DEFAULTS_SCHEMA.SYSTEM_DEFAULTS
Ansi NameSpace: TA
•
This example uses the SHOWLABEL command to locate the
SYSTEM_DEFAULTS table; only part of the output is included.
>>showlabel
nonstop_sqlmx_figaro.system_defaults_schema.system_defaults;
=============================================================
GuardianName: \FIGARO.$DATA08.ZSDA66LH.J63L2N00
AnsiName:
NONSTOP_SQLMX_FIGARO.SYSTEM_DEFAULTS_SCHEMA.SYSTEM_DEFAULTS
AnsiNameSpace: TA
ObjectSchemaVersion: 1200
ObjectFeatureVersion: 1200
Owner: SUPER.SUPER
Locating MXCS Schema Tables
On a local node, the anchor file $SYSTEM.ZSQLMX.MXANCHOR contains a pointer to
the location of the system catalog. The system catalog contains the MXCS_SCHEMA,
which contains tables used by MXCS and the user metadata tables. The MXCS
schema tables are located on the same volume as the system schema tables, but in
the subvolume ZSD1. The underlying Guardian names of the tables in this schema
have preassigned names.