RDF System Management Manual

NonStop SQL/MX and RDF
HP NonStop RDF System Management Manual—524388-003
15-3
Creating NonStop SQL/MX Primary and Backup
Databases from Scratch
Where catalog is the local catalog, node is the remote system where you want
the local catalog registered, and volume is where the local catalog is to be
registered on the remote system.
For example, the following command (if executed on the primary system) registers
the primary catalog on volume $DATA00 of the backup system:
REGISTER CATALOG pcat ON \bnode.$data00;
The following command (if executed on the backup system) registers the backup
catalog on volume $DATA00 of the primary system:
REGISTER CATALOG bcat ON \pnode.$data00;
4. Create the schema on the primary system.
If you do not use the LOCATION clause, NonStop SQL/MX will set the subvolume
itself. In that case, you must query NonStop SQL/MX to obtain the subvolume
name because the subvolume name is needed when creating the schema on the
backup system.
If you specify the LOCATION clause, the subvolume name must start with "ZSD"
and the entire name must be eight characters in length.
For example, if issued on the primary system the following command (without a
LOCATION clause) creates a schema called PCAT.SCH on the primary system:
CREATE SCHEMA PCAT.SCH;
If you omit the LOCATION clause, then, after creating the schema, you must use
the following query to obtain the subvolume of the schema (where you fill in the
correct node-name, schema-name, and catalog-name):
SELECT S.schema_subvolume
FROM NONSTOP_SQLMX_node-name.system_schema.schemata S,
NONSTOP_SQLMX_node-name.system_schema.catsys C
WHERE S.schema_name = 'schema-name' AND
C.cat_name = 'catalog-name' AND
S.cat_uid = C.cat_uid;
Note that node-name is a Guardian system name excluding the backslash (\).
In the following example, the node-name is PNODE, the schema-name is SCH,
and the catalog-name is PCAT.
SELECT S.schema_subvolume
FROM NONSTOP_SQLMX_PNODE.system_schema.schemata S,
NONSTOP_SQLMX_PNODE.system_schema.catsys C
WHERE S.schema_name = 'SCH' AND
C.cat_name = 'PCAT' AND
S.cat_uid = C.cat_uid;