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

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-10
SCHEMATA Tabl e
SCHEMATA Table
SCHEMATA is a metadata table in
NONSTOP_SQLMX_nodename.SYSTEM_SCHEMA that lists all schemas that have
definitions on the node.
Schema names that are regular identifiers are stored in uppercase letters. Schema
names that are delimited identifiers are stored as is, without surrounding quotation
marks.
SCHEMA_REPLICAS Table
SCHEMA_REPLICAS is a metadata table in
NONSTOP_SQLMX_nodename.SYSTEM_SCHEMA that lists locations of all replicas
for all schemas that have definitions on the node.
Column Name Data Type Description
*1 CAT_UID LARGEINT UID of catalog for schema; link to CATSYS
*2 SCHEMA_NAME CHAR(128) Schema name
3 SCHEMA_UID LARGEINT UID of schema; link to OBJECTS
4 SCHEMA_OWNER INT Owner's user ID
5 SCHEMA_VERSION INT Version of schema: 1200
6 SCHEMA_SUBVOLUME CHAR(8) Name of Guardian subvolume where objects
from schema are stored.
7 CURRENT_OPERATION CHAR(2) Reserved for future use
8 SOURCE_VERSION INT Reserved for future use
9 TARGET_VERSION INT Reserved for future use
* Indicates primary key
Column Name Data Type Description
*1 SCHEMA_UID LARGEINT UID of schema; link to SCHEMATA
*2 NODE_NAME CHAR(8) Expand node name of node where
replica resides, including leading “\”
(backslash)
* Indicates primary key