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

order by schema_name
for read uncommitted access;
SCHEMA_UID
--------------------
SCHEMA_NAME
------------------------------
1950548695223685006
1950548695240365422
DEFINITION_SCHEMA_VERSION_3000
INVENT
1950548695235454934
1950548695238563835
PERSNL
SALES
Displaying the Guardian Location of the Metadata Tables for a Catalog
• This example displays the Guardian subvolumes where the system and user tables are located
for schemas in the catalog SAMDBCAT:
>> set schema nonstop_sqlmx_<system name>.system_schema;
--- SQL operation complete.
>> select substring(schema_name, 1, 30) as schema_name,
local_smd_volume, schema_subvolume
from schemata s, catsys c
where s.schema_name = 'DEFINITION_SCHEMA_VERSION_<schema version>'
and c.cat_name = 'SAMDBCAT'
and s.cat_uid = c.cat_uid
order by schema_name
for read uncommitted access;
SCHEMA_SUBVOLUME
----------------
LOCAL_SMD_VOLUME
----------------
SCHEMA_NAME
------------------------------
ZSD8F9M1$SYSTEMDEFINITION_SCHEMA_VERSION_3000
--- 1 row(s) selected.
• This example uses the FILES command from the TACL prompt to display the list of files in the
definition schema. The table names are hard-coded names.
1> files $data08.zsdaj6mx
$DATA08.ZSDAJ6MX
CKCOLU01
COLUMN01
CKCOLU00
COLUMN00
ACPTHC01
COLPRI01
ACPTHC00
COLPRI00
ACCPTH01
CKTBLU01
ACCPTH00
CKTBLU00
KYCLU001KYCLU000DDPLKS01DDPLKS00DDLKS001DDLKS000
MVRGRP01MVRGRP00MPPART01MPPART00MODULE01MODULE00
MVSJCL01MVSJCL00MVSCOL01MVSCOL00MVS00001MVS00000
OBJECT01OBJECT00MVSUSE01MVSUSE00MVSTIN01MVSTIN00
REPLIC01REPLIC00REFCON01REFCON00PARTNS01PARTNS00
TBLCON01TBLCON00ROUTIN01ROUTIN00RIUU0001RIUU0000
TRGCU001TRGCU000TBLTEX01TBLTEX00TBLPRI01TBLPRI00
VCOLTA01
VIEWS001
VCOLTA00
VIEWS000
TRIGS001
VCOLU001
TRIGS000
VCOLU000
TRGUSD01
VCOLTC01
VWTBLU01
TRGUSD00
VCOLTC00
VWTBLU00
Displaying the Attributes of a Catalog
This example is a combination of the previous examples. It displays all catalog attributes:
>> set schema nonstop_sqlmx_<system name>.system_schema;
--- SQL operation complete.
>> select
substring(c.cat_name,1,10) as name,
case c.replication_rule
120 Querying SQL/MX Metadata