RDF System Management Manual

NonStop SQL/MX and RDF
HP NonStop RDF System Management Manual—524388-003
15-9
Creating the Fuzzy Copy on the Primary System
2. Create a temporary schema for your temporary catalog. Follow the instructions
given in Step 2 of the procedure Creating a NonStop SQL/MX Backup Database
From an Existing Primary Database, above (but follow those instructions on your
primary system instead of on the backup system). Note, the name of the
temporary schema must be identical to the name of the schema whose objects you
want replicated. You must also ensure that the subvolume name for the temporary
schema is identical to that of the schema whose objects you want replicated.
3. Create temporary objects in your temporary schema. Follow the guidelines outlined
in Creating a NonStop SQL/MX Backup Database From an Existing Primary
Database above, except that you must create these temporary objects on the
primary system and on different volumes from those used for your primary objects.
You can use the use the MXGNAMES utility as described under Step 4 of Creating
a NonStop SQL/MX Backup Database From an Existing Primary Database, above,
to generate the LOCATION clauses for the temporary objects, modifying the
volume names as necessary and using the primary node name for the -node
option. Alternatively, you can use the SHOWDDL command to obtain the fully
qualified filenames of the objects you want replicated and specify the same
Guardian subvol.filenames in the corresponding LOCATION clauses when creating
the temporary objects.
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.