SQL/MX 2.x Reference Manual (H06.04+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-9
CATSYS Table
CATSYS Table
CATSYS is a metadata table in NONSTOP_SQLMX_nodename.SYSTEM_SCHEMA
that describes all catalogs visible from the node:
Catalog names that are regular identifiers are stored in uppercase letters. Catalog
names that are delimited identifiers are stored as is, without surrounding quotation
marks.
All other character columns store letters in uppercase.
CAT_REFERENCES Table
CAT_REFERENCES CATSYS is a metadata table in
NONSTOP_SQLMX_nodename.SYSTEM_SCHEMA that describes the locations of
catalog replicas for catalogs visible from the node:
Column Name Data Type Description
*1 CAT_NAME CHAR(128) Catalog name
2 CAT_UID LARGEINT UID for catalog; link to SCHEMATA
and CAT_REFERENCES
3 REPLICATION_RULE CHAR(2) A if automatic schema replication rule
M if manual schema replication rule
4 LOCAL_SMD_VOLUME CHAR(8) Volume where SMD and UMD tables
in this catalog reside on the local
node, including leading “$” sign.
5 LOCAL_USER_SCHEMA_COUNT INT Reserved for future use
6 CAT_OWNER INT Catalog owner’s user ID
* Indicates primary key
Column Name Data Type Description
*1CAT_UID LARGEINT UID for catalog; link to CATSYS
*2 NODE_NAME CHAR(8) Expand node name of node where
replica resides, including leading “\”
(backslash)
3 SMD_VOLUME CHAR(8) Volume where SMD tables reside on
the node, including leading “$”
(dollar sign)
4 REPLICATION_RULE CHAR(2) A if automatic schema replication
rule
M if manual schema replication rule