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

Adding, Altering, and Dropping SQL/MX Database
Objects
HP NonStop SQL/MX Installation and Management Guide—523723-004
9-14
Adding SQL/MP Aliases
name must match the subvolume name indicated in the system schema column
SCHEMA_SUBVOLUME, described in the system schema table SCHEMATA.
NonStop SQL/MX does not prevent you from specifying a subvolume name that is
already in use by another schema. However, HP strongly recommends that each
schema use a different subvolume. This avoids problems when RDF and other
features are needed.
Schema names that being with DEFINITION_SCHEMA_VERSION_ are reserved (in
all catalogs) for system metadata. You cannot create schemas with these names in
user catalogs.
For more information, see the SQL/MX Reference Manual.
Steps for Adding a Schema
1. Start an MXCI session. Enter a LOG command to initiate a log file for statements
and commands entered in this session. Keep the log for your records.
2. Determine a name for the schema you wish to add.
3. Query the system metadata to ensure the new schema name is unique among
existing schema names in the catalog.
4. Enter the CREATE SCHEMA statement,.
For more information and examples of creating schemas, see Creating Schemas on
page 7-8.
Adding SQL/MP Aliases
Use the CREATE SQLMP ALIAS statement to add an SQL/MP alias to your SQL/MX
database.
For more information, see the SQL/MX Reference Manual.
Steps for Adding an SQL/MP Alias
1. Start an MXCI session. Enter a LOG command to initiate a log file for statements
and commands entered in this session. Keep the log for your records.
2. Determine a name for the SQL/MP alias you wish to add.
3. Query the system metadata to ensure the new SQL/MP alias name is unique
among existing table, view, SQL/MP alias, and SPJ names in the schema.
4. Enter the CREATE SQLMP ALIAS statement.
For more information and examples of creating SQL/MP aliases, see the SQL/MX
Reference Manual.