SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Metadata Tables
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
10-2
SQL/MX Metadata Catalogs

An asterisk preceding a column number indicates that the column is part of the
clustering key, which is also called as primary key. Unless otherwise stated, the
primary key is in column number sequence.

Unless otherwise stated, timestamps are Julian timestamps.

Unless otherwise stated, character data is stored in uppercase letters except for
character columns that contain delimited identifiers, which are stored as is, but
without the surrounding double quotes, and with two consecutive double quotes
collapsed into one double quote.

Unless otherwise stated, CHAR(n) in the data type field without a character set
qualifier is associated with the ISO88591 character set. All character types are
searched or sorted with the DEFAULT (binary) collation with the PAD SPACE
characteristic.
For SQL/MX Release 3.2, these tables are visible but are not supported and are
reserved for future use:

EXCEPTION_USAGE

HISTOGRAM_FREQ_VALS

MVGROUPS

MVS

MVS_COLS

MVS_JOIN_COLS

MVS_TABLE_INFO

MVS_USED

MVS_TABLE_INFO_UMD

MVS_USED_UMD

SCH_PRIVILEGES

SYNONYM_USAGE
SQL/MX Metadata Catalogs
There is one system catalog per node where NonStop SQL/MX has been initialized.
The system catalog name is NONSTOP_SQLMX_nodename. All metadata tables in
the system catalog are stored on the volume specified as the system metadata volume
during installation. There are six schemas in the system catalog:

DEFINITION_SCHEMA_VERSION_vernum.

MXCS_SCHEMA

SYSTEM_DEFAULTS_SCHEMA

SYSTEM_SCHEMA

SYSTEM_SECURITY_SCHEMA

SYSTEM_SQLJ_SCHEMA
You can create as many user catalogs as you wish on a node. Each will contain a
DEFINITION_SCHEMA_VERSION_vernum schema.