RDF System Management Manual

NonStop SQL/MX and RDF
HP NonStop RDF System Management Manual—524388-003
15-14
Online Synchronization for a Single Partition
Online Synchronization for a Single Partition
You must first determine the key ranges for each of your partitions.
Follow the steps described in Online Database Synchronization With NonStop SQL/MX
Objects, above. Note that in this case, however, you are only dealing with a single
partition. If you create a temporary table on your primary system, you only need to
populate the one partition with the INSERT statement shown in Offline Synchronization
for a Single Partition, above.
If you synchronize the backup partition directly from the primary system, first delete all
rows from the backup partition, as described in Offline Synchronization for a Single
Partition, above, and then load the data into the backup partition using the INSERT
statement also described in that topic.
Correcting Incorrect NonStop SQL/MX Name
Mapping
Primary and Backup ANSI Catalog Are the Same
If you created the primary and backup catalogs and used the same name for both, you
cannot use the REGISTER CATALOG command to make either catalog visible on the
other system. So you cannot perform NonStop SQL/MX operations that refer to both
catalogs, such as the method for populating NonStop SQL/MX objects for online
database synchronization, nor use more advanced ANSI name support features in a
future release.
To correct the problem:
1. Use the BACKUP utility to store one entire catalog on tape.
2. Drop the entire catalog.
3. Use the RESTORE utility to put the catalog back on disk, but specify a different
target catalog name, taking care that you explicitly map all source Guardian file
names to identical targets using the LOCATION clause.
Alternatively, you can drop the entire catalog, and then recreate it and all dependent
schemas and objects.