SQL/MX 3.x Installation and Management Guide (H06.22+, J06.11+)

Querying SQL/MX Metadata
HP NonStop SQL/MX Installation and Management Guide—640325-001
8-21
Locating MXCS Schema Tables
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
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.