SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—640322-001
10-11
SCHEMA_REPLICAS Table
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.
Definition Schema Tables
ACCESS_PATHS Table
ACCESS_PATHS is a metadata table in DEFINITION_SCHEMA_VERSION_vernum
that describes physical instances of data in the catalog. (A physical instance of data is
a simple table, an index, or a partition of a table or index.)
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
Column Name Data Type Description
*1 TABLE_UID LARGEINT UID of base table; link to OBJECTS
*2 ACCESS_PATH_UID LARGEINT If path is index, UID of index;
otherwise, UID of base table
3 ACCESS_PATH_TYPE CHAR(2) BT Base Table
IX Index
4 COLUMN_COUNT INT Number of rows in table
ACCESS_PATH_COLUMNS directly
associated with this access path
5 UNIQUE_COLUMN_COUNT INT Number of rows in table
ACCESS_PATH_COLUMNS in
unique key for this access path
6 VALID_DATA CHAR(2) Y if valid data
N if not
7 RECORD_SIZE INT Number of bytes in each logical
record
8 UNIQUES CHAR(2) Y if each row in this access path is
unique
N if not
9 EXPLICIT CHAR(2) Y if user-created index
N if not
10 CLUSTERING_SCHEME CHAR(2) Physical organization of this access
path:
KS if by key