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

--- SQL operation complete.
>>select substring(object_name, 1, 23) as table_name,
substring(p.system_name, 1, 15) as system,
p.data_source,
p.file_suffix
from partitions p, objects o
where
o.object_type = 'BT' and
o.object_name = 'SYSTEM_DEFAULTS' and
o.object_uid = p.object_uid and
o.schema_uid =
(select schema_uid
from nonstop_sqlmx_dmr15.system_schema.schemata
where
schema_name = 'SYSTEM_DEFAULTS_SCHEMA' and
cat_uid =
-- get catalog uid for CAT
(select cat_uid
from nonstop_sqlmx_dmr15.system_schema.catsys
where cat_name = 'NONSTOP_SQLMX_DMR15'
)
)
for read uncommitted access;
FILE_SUFFIX
------------------
DATA_SOURCE
-----------
SYSTEM
--------
TABLE_NAME
-------------
ZSDA984F.M26FB700$DATA08\DMR15SYSTEM_DEFAULTS
--- 1 row(s) selected.
>> exit;
# ls /G/data08/zsda984f
bd2xt800 d96rs800 fpjcx800 hpz9p800 l2jnr800
q956v800 bd2xt801 d96rs801 fpjcx801 hpz9p801
l2jnr801 q956v801
# mxtool info \$data08.zsda984f.fpjcx800
Hewlett-Packard NonStop(TM) SQL/MX MXTOOL Utility 3.1
(c) Copyright 2003, 2004-2011 Hewlett-Packard Development Company, LP.
File Name: \DMR15.$DATA08.ZSDA984F.FPJCX800
Object Schema Version: 3000
Ansi Name:
NONSTOP_SQLMX_DMR15.SYSTEM_DEFAULTS_SCHEMA.SYSTEM_DEFAULTS
Ansi NameSpace: TA
• This example uses the SHOWLABEL command to locate the SYSTEM_DEFAULTS table; only
part of the output is included.
>>showlabel nonstop_sqlmx_<system
name>.system_defaults_schema.system_defaults;
=============================================================
GuardianName: \DMR15.$DATA02.ZSD5VXWZ.M26FB700
AnsiName:
NONSTOP_SQLMX_DMR15.SYSTEM_DEFAULTS_SCHEMA.SYSTEM_DEFAULTS
AnsiNameSpace: TA
ObjectSchemaVersion: 3000
ObjectFeatureVersion: 1200
116 Querying SQL/MX Metadata