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-15
Displaying System Schema Information
for read uncommitted access
order by object_name;
Note that "my "" catalog" is in external format, and 'SALES' and 'my " catalog' are
in internal format. The query does not work correctly if the internal and external names
are incorrect.
Displaying System Schema Information
Topics in this subsection:
•
Locating System Schema Tables on page 8-15
•
Locating System Defaults Schema Tables on page 8-18
•
Locating MXCS Schema Tables on page 8-21
This table shows the locations of system schema information:
For detailed information about system schema tables, see the SQL/MX Reference
Manual.
Schema NONSTOP_SQLMX_nodename.SYSTEM_SQLJ_SCHEMA on each node
contains only an SPJ; no tables are associated with it. For more information about
SYSTEM_SQLJ_SCHEMA, see the SQL/MX Reference Manual.
Locating System 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
SYSTEM_SCHEMA, which contains tables that define the location of all the catalogs
and schemas visible on the local node. The underlying Guardian names of the tables in
this schema have preassigned names and belong to the preassigned subvolume
ZSD0.
Schema Table Type Schema Location on Each Node
System schema tables
NONSTOP_SQLMX_nodename.SYSTEM_SCHEMA
System defaults schema tables NONSTOP_SQLMX_nodename.SYSTEM_
DEFAULTS_SCHEMA
MXCS (ODBC) schema tables NONSTOP_SQLMX_nodename.MXCS_SCHEMA