SQL/MX 2.x Installation and Management Guide (H06.10+, J06.03+)

Introduction to SQL/MX Database Management
HP NonStop SQL/MX Installation and Management Guide—544536-007
1-9
SQL/MX Database Object Types
For more information about these and other SQL/MX metadata tables, see Section 8,
Querying SQL/MX Metadata and the SQL/MX Reference Manual.
SQL/MX Database Object Types
Table 1-2 describes SQL/MX object types. For information about SQL/MP objects, see
the SQL/MP Installation and Management Guide and the SQL/MP Reference Manual.
Table 1-1. SQL/MX Metadata Schemas
Schema Name Schema Contents
SYSTEM_SCHEMA One set of five system schema tables resides in the
system catalog under this schema. Use these system
metadata tables, which record the existence of
catalogs and schemas, to find the correct user catalog
on which to perform data lookup. When the catalog is
located, the definition schema is read to obtain details
about the object being queried (for example, a list of
Guardian locations for a table’s partitions).
SYSTEM_DEFAULTS_SCHEMA The SYSTEM_DEFAULTS table resides in the system
catalog under this schema. This user metadata table
contains the default settings for options and other
attributes used with MXCI commands and SQL/MX
statements.
MXCS_SCHEMA Five NonStop SQL/MX Connectivity Service (MXCS)
tables reside in the system catalog under this schema.
For more information, see the SQL/MX Reference
Manual.
SYSTEM_SQLJ_SCHEMA The stored procedure VALIDATEROUTINE and
VALIDATEROUTINE2 reside in the system catalog
under this schema. This schema contains no metadata
tables.
DEFINITION_SCHEMA
_VERSION_vernum
One set of schema definition tables resides in each
user catalog under this schema. These system
metadata tables are created for a given catalog when
the first CREATE SCHEMA statement is executed for
the catalog. They store and maintain definitions of the
objects in the catalog.
user schemas Two histograms tables (HISTOGRAMS and
HISTOGRAM_INTERVALS) reside in each user
schema. These user metadata tables describe how
data is distributed with respect to a column or group of
columns within a table. The optimizer uses these
statistics to create efficient access plans.
VALIDATEROUTINE2 is the internal SPJ of system_SQLJ_schema that is supported on systems running
J06.05 and later J-series RVUs and H06.16 and later H-series RVUs. However, VALIDATEROUTINE is used
on systems running J06.04 and earlier J-series RVUS and H06.15 and earlier H-series RVUs.