




|
da questo dispositivo ha anche altre istruzioni :
Facilità d'uso
Querying SQL/MX Metadata
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
$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
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)
HP NonStop SQL/MX Installation and Management Guide—640325-001
8- 14
... Questo manuale è adatto anche per i modelli :
Computer - HP Integrity NonStop J-Series (1.71 mb)