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

ASSOC200 ASSOC201 DATASO00 DATASO01 ENVIRO00 ENVIRO01
NAME2I00 NAME2I01 RESOUR00 RESOUR01
$DATA02 ZSD1 12> fup info assoc200, detail
$DATA02.ZSD1.ASSOC200 27 Jan 2011, 14:09
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: 26 Jan 2011, 0:37
EOF: 12288 (0.0% USED)
EXTENTS ALLOCATED: 1
INDEX LEVELS: 1
PARTITION ARRAY FORMAT2ENABLED
• This is an example from the OSS prompt:
# cat /G/system/zsqlmx/mxanchor
SQLMX_MetaData_Loc=$DATA02
# ls /G/data02/zsd0
catref00 catsys00 schema00 schrep00
catref01 catsys01 schema01 schrep01
# /usr/tandem/sqlmx/bin/mxtool info \$data02.zsd0.catsys00
Hewlett-Packard NonStop(TM) SQL/MX MXTOOL Utility 3.0
(c) Copyright 2003, 2004-2010 Hewlett-Packard Development Company, LP.
File Name: \DMR15.$DATA02.ZSD0.CATSYS00
Object Schema Version: 3000
Ansi Name: NONSTOP_SQLMX_DMR15.SYSTEM_SCHEMA.CATSYS
Ansi NameSpace: TA
Locating System Defaults Schema Tables
On a local node, the anchor file $SYSTEM.ZSQLMX.MXANCHOR contains a pointer to the location
of the system catalog. Every system catalog contains a special schema called the
SYSTEM_DEFAULTS_SCHEMA, which contains the SYSTEM_DEFAULTS table. The associated
Guardian file name for the SYSTEM_DEFAULTS table is randomly generated; it is not preassigned
like tables in the SYSTEM_SCHEMA.
114 Querying SQL/MX Metadata