RDF/IMP, IMPX, and ZLT System Management Manual

NonStop SQL/MX and RDF

HP NonStop RDF/IMP, IMPX, and ZLT System Management Manual—524388-002

15-9

Creating the Fuzzy Copy on the Primary System

For example, suppose you have a primary table that has two partitions, for which

you want make a fuzzy copy, and the fully qualified Guardian names are:

$DATA01.ZSDABCDE.HWEFGH00

$DATA02.ZSDABCDE.HWEFHJ00

When you create the temporary table, you might list the following Guardian names

in the LOCATION clause:

$DATAXX.ZSDABCDE.HWEFGH00

$DATAYY.ZSDABCDE.HWEFHJ00

4. Populate the temporary tables.

INSERT INTO <temporary table> SELECT * FROM <primary table>;

5. Use BACKUP to put the temporary objects onto tape.

6. Create a catalog on your backup system to correspond to your primary catalog on

your primary system whose objects you want RDF to replicate.

7. Create the schema on the backup node using the same schema name and the

same subvolume name as the schema for your primary database. See Step 4 of

the procedure Creating NonStop SQL/MX Primary and Backup Databases from

Scratch, above, for details and an example.

8. If you want each catalog to be seen from both systems, register your primary and

backup catalogs.

To register the primary catalog on the backup system, issue a REGISTER

CATALOG command on the primary system.

To register the backup catalog on the primary system, issue a REGISTER

CATALOG command on the backup system.

The format of the REGISTER CATALOG command is:

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 the backup system:

The following command (if executed on the backup system) registers the backup

catalog on the primary system: