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-23
Locating MXCS Schema Tables
This example uses TACL commands to locate the MXCS schema tables.
1> fup copy $system.zsqlmx.mxanchor
SQLMX_MetaData_Loc=$DATA02
1 RECORDS TRANSFERRED
2> volume $data02.zsd1
3> files
$DATA02.ZSD1
ASSOC200 ASSOC201 DATASO00 DATASO01 ENVIRO00 ENVIRO01
NAME2I00 NAME2I01 RESOUR00 RESOUR01
4> fup info assoc200, detail
$DATA02.ZSD1.ASSOC200 28 Jan 2011, 12:25
SQL ANSI TABLE
ANSI NAME NONSTOP_SQLMX_DMR15.MXCS_SCHEMA.ASSOC2DS
RESOURCE FORK \DMR15.$DATA02.ZSD1.ASSOC201
SYSTEM METADATA \DMR15.$DATA02.ZSD0
VERSION 1200
TYPE K
FORMAT 2
CODE 563
EXT ( 128 PAGES, 256 PAGES, MAXEXTENTS 512 )
PACKED REC 48
BLOCK 4096
KEY ( COLUMN 0, ASC ,
COLUMN 1, ASC )
AUDIT
BUFFERED
AUDITCOMPRESS
OWNER -1
SECURITY (RWEP): *SQL
DATA MODIF: 19 Jan 2011, 17:24, OPEN
CREATION DATE: 27 Nov 2009, 19:40
REDEFINITION DATE: 27 Nov 2009, 19:40
LAST OPEN: 28 Jan 2011, 3:01
EOF: 12288 (0.0% USED)
EXTENTS ALLOCATED: 1
INDEX LEVELS: 1
PARTITION ARRAY FORMAT2ENABLED