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-21
Locating MXCS Schema Tables
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.
This example uses TACL commands to locate the MXCS schema tables.
1> fup copy $system.zsqlmx.mxanchor
SQLMX_MetaData_Loc=$DATA08
2> volume $data08.zsd1
3> files
$DATA08.ZSD1
ASSOC200 ASSOC201 DATASO00 DATASO01 ENVIRO00 ENVIRO01
NAME2I00 NAME2I01 RESOUR00 RESOUR01
4> fup info assoc200, detail
$DATA08.ZSD1JHD.ASSOC200 12 Feb 2004, 12:41
SQL ANSI TABLE
ANSI NAME NONSTOP_SQLMX_FIGARO.MXCS_SCHEMA.ASSOC2DS
RESOURCE FORK \FIGARO.$DATA08.ZSD1.ASSOC201
SYSTEM METADATA \FIGARO.$DATA08.ZSD0
VERSION 1200
TYPE K
FORMAT 2
CODE 563
EXT ( 128 PAGES, 256 PAGES, MAXEXTENTS 512 )
PACKED REC 48
BLOCK 4096
KEY ( COLUMN 512, TYPE 0, LENGTH 0, DESC ,
COLUMN 256, TYPE 256, LENGTH 0, DESC )
AUDIT
BUFFERED
AUDITCOMPRESS
OWNER -1
SECURITY (RWEP): *SQL
DATA MODIF: 12 Feb 2004, 7:51
CREATION DATE: 12 Feb 2004, 7:51
REDEFINITION DATE: 12 Feb 2004, 7:50
LAST OPEN: NEVER OPENED
EOF: 0 (0.0% USED)
EXTENTS ALLOCATED: 0
INDEX LEVELS: 0
PARTITION ARRAY FORMAT2ENABLED