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-17
Locating System Schema Tables
•
This example also uses TACL commands to locate the MXCS schema tables on
ZSD1.
1> fup copy $system.zsqlmx.mxanchor
SQLMX_MetaData_Loc=$DATA08
2> volume $data08.zsd1
3> files
$DATA08.ZSD1
ASSOC200 ASSOC201 B7NMCJ00 B7NMCJ01 DATASO00 DATASO01
DTQSFJ00 DTQSFJ01 ENVIRO00 ENVIRO01 NAME2I00 NAME2I01
PX1KHJ00 PX1KHJ01 Q4DNDJ00 Q4DNDJ01 RESOUR00 RESOUR01
Z9FPGJ00 Z9FPGJ01
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