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

>> MODIFY TABLE cat3.sch3.ordersh add partition
+> location $DATA04;
--- SQL operation complete.
In response to this command, a portion of the data in each of the original three partitions is moved
automatically to the fourth partition, rebalancing the data evenly across the four partitions.
For more detailed examples of adding, modifying, and deleting range-partitioned and
hash-partitioned tables and indexes, see “Using MODIFY to Manage Table and Index Partitions”
(page 182).
Adding Schemas
To add a schema to a catalog, use the CREATE SCHEMA statement. If you specify an optional
subvolume name in the CREATE SCHEMA statement, follow these guidelines:
• The name must begin with the letters ZSD, followed by a letter, not a digit (for example, ZSDa,
not ZSD2).
• The name must be exactly eight characters long.
• All Guardian files representing data in a particular schema must have the same subvolume
name regardless of the volume on which they reside. This subvolume name must match the
subvolume name indicated in the system schema column SCHEMA_SUBVOLUME, described
in the system schema table SCHEMATA.
NonStop SQL/MX prevents you from specifying a subvolume name that is already in use by another
schema. However, when the RDF product is used to maintain a duplicate database on another
node, you must use the same subvolume for the backup database. If the catalogs are visible on
the other nodes, use the REPEAT USE ALLOWED option while creating the schema.
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, see “Creating Schemas” (page 77).
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.
158 Adding, Altering, and Dropping SQL/MX Database Objects