SQL/MX 3.2.1 Management Manual (H06.26+, J06.15+)

2> volume $data02.zsd0
$DATA02 ZSD0 3> files
$DATA02.ZSD0
CATREF00 CATREF01 CATSYS00 CATSYS01 SCHEMA00 SCHEMA01
SCHREP00 SCHREP01
4> fup info catref00, detail
$DATA02.ZSD0.CATREF00 27 Jan 2011, 19:05
SQL METADATA TABLE
ANSI NAME
NONSTOP_SQLMX_DMR15.SYSTEM_SCHEMA.CAT_REFERENCES
RESOURCE FORK \DMR15.$DATA02.ZSD0.CATREF01
SYSTEM METADATA \DMR15.$DATA02.ZSD0
VERSION 1200
TYPE K
FORMAT 2
CODE 564
EXT ( 128 PAGES, 256 PAGES, MAXEXTENTS 512 )
PACKED REC 30
BLOCK 32768
KEY ( COLUMN 0, ASC ,
COLUMN 1, ASC )
AUDIT
BUFFERED
AUDITCOMPRESS
OWNER -1
SECURITY (RWEP): *SQL
DATA MODIF: 27 Jan 2011, 16:42, OPEN
CREATION DATE: 27 Nov 2009, 19:40
REDEFINITION DATE: 27 Nov 2009, 19:40
LAST OPEN: 27 Jan 2011, 17:14
EOF: 98304 (0.0% USED)
EXTENTS ALLOCATED: 1
INDEX LEVELS: 1
PARTITION ARRAY FORMAT2ENABLED
• 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
$DATA02 ZSDI 9> fup copy $system.zsqlmx.mxanchor
SQLMX_MetaData_Loc=$DATA02
1 RECORDS TRANSFERRED
$DATA02 ZSDI 10> volume $data02.zsd1
$DATA02 ZSD1 11> files
$DATA02.ZSD1
Displaying System Schema Information 113