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

Metadata Tables
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
10-2
SQL/MX Metadata Catalogs
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.1, 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.