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

when 'A' then 'AUTOMATIC'
when 'M' then 'MANUAL'
else 'UNKNOWN'
end as rep_rule,
c.local_smd_volume as smd_vol,
c.local_user_schema_count as schema_cnt,
c.cat_owner as owner
from catsys c
where c.cat_name = 'SAMDBCAT'
for read uncommitted access;
OWNER
-----------
SCHEMA_CNT
-----------
SMD_VOL
--------
REP_RULE
---------
NAME
----------
655350$DATA08AUTOMATICSAMDBCAT
Displaying Schema Information
This subsection discusses:
• “Displaying a Schema UID” (page 121)
• “Displaying all Schemas Visible on a Node” (page 122)
• “Displaying all Objects in a Schema” (page 122)
• “Displaying the Attributes of a Schema” (page 123)
• “Displaying the Owner of a Schema” (page 124)
Related topics:
• “Locating System Schema Tables” (page 112)
• “Locating System Defaults Schema Tables” (page 114)
• “Displaying all Tables in a Schema” (page 127)
• “Displaying all Views in a Schema” (page 129)
• “Displaying the Schema Version” (page 148)
• “Displaying the System Schema Version” (page 148)
• “Displaying the Object Schema Version (OSV)” (page 148)
The SCHEMATA table on each node is a system schema table that describes all the schemas visible
from the node. For more information about all metadata tables, see Figure 3 (page 109) in this
manual or the SQL/MX Reference Manual.
Displaying a Schema UID
Because schema names can be up to 128 characters in length, each schema is assigned a unique
identifier (UID). Use the schema UID to efficiently join between metadata tables to display
relationships.
This example, run on the system in which the catalog is defined, displays a schema name, the
schema UID, and the node where the schema is defined:
>> set schema nonstop_sqlmx_<system name>.system_schema;
--- SQL operation complete.
>> select substring(schema_name,1,30) as schema_name,
s.schema_uid, node_name
from schemata s, catsys c, cat_references cr
where c.cat_name = 'SAMDBCAT'
and c.cat_uid=s.cat_uid
Displaying Schema Information 121