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-17
Locating System Defaults Schema Tables

This is an example from the OSS prompt:
# cat /G/system/zsqlmx/mxanchor
SQLMX_MetaData_Loc=$DATA02
# ls /G/data02/zsd0
catref00 catsys00 schema00 schrep00
catref01 catsys01 schema01 schrep01
# /usr/tandem/sqlmx/bin/mxtool info \$data02.zsd0.catsys00
Hewlett-Packard NonStop(TM) SQL/MX MXTOOL Utility 3.0
(c) Copyright 2003, 2004-2010 Hewlett-Packard Development
Company, LP.
File Name: \DMR15.$DATA02.ZSD0.CATSYS00
Object Schema Version: 3000
Ansi Name: NONSTOP_SQLMX_DMR15.SYSTEM_SCHEMA.CATSYS
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.