Manualshelf

SQL/MX Comparison Guide for SQL/MP Users

ManualsBrandsHP ManualsServerHP NonStop G-Series
919293949596979899100
Data Definition Language (DDL) Differences
HP NonStop SQL/MX Comparison Guide for SQL/MP Users—523735-003
6-3
Metadata
same node. Normally, an SQL program is registered in a catalog, too. For more
information, see the SQL/MP Reference Manual.
NonStop SQL/MP allows you to create catalogs and to drop system catalogs.
Metadata
The system catalog is NONSTOP_SQLMX_nodename. SQL/MX metadata is
organized within these system schemas:
SQL/MX’s metadata is on the same subvolume as the system catalog, which you
specify when you install NonStop SQL/MX.
SQL/MP metadata, also called the Data Dictionary, is organized by disk. It consists of
all the catalogs on a network and labels for each file on the volume. The label includes
the name or the object, the name of the catalog that describes the object, and other
information about the file.
SQL/MP metadata is the combination of system catalog metadata and user catalog
metadata. NonStop SQL/MP creates the system catalog when you issue the CREATE
SYSTEM CATALOG command, in whatever catalog you specify. The default is
$SYSTEM.SQL. Each catalog of user metadata resides on its own Guardian
subvolume.
Previous releases of NonStop SQL/MX use a different table scheme for metadata
where metadata resided in SQL/MP tables registered in the SQL/MP catalog. For
SQL/MX Release 2.0, metadata resides in SQL/MX metadata tables. The MIGRATE
utility is provided to move metadata from previous releases of NonStop SQL/MX to
current metadata tables. For more information about this utility, see the SQL/MX
Installation and Management Guide and the SQL/MX Reference Manual.
SYSTEM_SCHEMA System schema tables that list information such as
catalogs and schemas in the system.
DEFINITION_SCHEMA_
VERSION_versnum
Definition schema tables that list information such as
columns in tables, constraints, partitions, views,
procedures and so on.
SYSTEM_DEFAULTS_
SCHEMA
User-provided system defaults.
MXCS_SCHEMA MXCS subsystem data source and governing
information.
SYSTEM_SQLJ_SCHEMA System schema that contains only the stored
procedure VALIDATEROUTINE, which is for internal
use.