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

Creating an SQL/MX Database
HP NonStop SQL/MX Installation and Management Guide—544536-007
7-5
Using the Subvolume Option in the CREATE
SCHEMA Statement
where subvolume is the name of the designated schema subvolume for the schema
in which the table or index is being created, and file-name is a Guardian file name
that conforms to the rules specified in SQL/MX Subvolume Naming Guidelines on
page 7-3. Otherwise, an error is generated.
When you create SQL/MX tables and indexes, you would typically use the LOCATION
clause to partition data on particular volumes, without regard to the Guardian
subvolume and file name assigned to these partitions. However, it might be necessary
to re-create a file with the exact same Guardian names that it was given when first
created.
You cannot use the LOCATION clause to specify a subvolume that is already in use by
another schema.
For more information about using the LOCATION clause, see the SQL/MX Reference
Manual.
Using the Subvolume Option in the CREATE SCHEMA Statement
The CREATE SCHEMA statement accepts an optional subvolume name, a
nonstandard HP extension. This option enables you to create an RDF backup
database. The subvolume name of each backup schema must match the subvolume
name of the corresponding primary schema. If you are not creating an RDF backup of
the database, you should omit the optional subvolume, in which case NonStop
SQL/MX generates a new and unique subvolume name for the schema. In all cases,
the schema subvolume name is written to the SCHEMA_SUBVOLUME column of the
system schema table
NONSTOP_SQLMX_system-name.SYSTEM_SCHEMA.SCHEMATA.
The format of the CREATE SCHEMA statement is:
CREATE SCHEMA schema-clause [schema-element]
where schema-clause is one of:
•
schema
•
schema AUTHORIZATION auth-id
•
schema AUTHORIZATION auth-id location-clause
•
schema location-clause
location-clause is:
LOCATION subvolume [reuse-clause]
reuse-clause is:
REPEAT USE ALLOWED
schema-element is one of:
•
table-definition
•
view-definition
•
grant-statement