RDF/IMP, IMPX, and ZLT System Management Manual

HP NonStop RDF/IMP, IMPX, and ZLT System Management Manual—524388-002
15-1
15
NonStop SQL/MX and RDF
RDF supports replication of NonStop SQL/MX user tables (file code 550) and indexes
(file code 552). These operations are supported in much the same way as they are
with NonStop SQL/MP, and the same types of data and DDL operations are replicated.
This section describes the following operations:
•
Creating NonStop SQL/MX primary and backup databases from scratch
•
Creating a NonStop SQL/MX backup database from an existing primary database
•
Synchronizing a NonStop SQL/MX database online
•
Synchronizing a single NonStop SQL/MX partition offline
•
Synchronizing a single NonStop SQL/MX partition online
•
Correcting incorrect NonStop SQL/MX name mapping
•
Querying metadata
•
Restoring to a specific location
•
Comparing NonStop SQL/MX tables
Given the way the name mapping works between NonStop SQL/MX objects and their
underlying Guardian file names, there are special considerations when setting up
NonStop SQL/MX objects to be replicated by RDF. This section describes those
issues.
The command interface for NonStop SQL/MX is MXCI.
Creating NonStop SQL/MX Primary and
Backup Databases from Scratch
To create a NonStop SQL/MX primary and backup database from scratch, perform the
following steps:
1. Create the catalog on the primary system.
CREATE CATALOG <catalog_name> LOCATION <optional_Guardian_location>;
For example, if issued on the primary system the command
CREATE CATALOG PCAT LOCATION $DATA01;
creates a catalog named PCAT on volume $DATA01 on the primary system.
For the rest of this procedure assume that the name of the primary system is
\PNODE and the name of the backup system is \BNODE.