RDF System Management Manual

NonStop SQL/MX and RDF
HP NonStop RDF System Management Manual—524388-003
15-13
Backup Partition Does Not Already Exist
4. Now load only the rows from the primary partition that you want synchronized into
the temporary partition:
INSERT INTO backup-table SELECT * FROM primary-table
WHERE key-column >= 'F' AND key-column < 'K';
5. Use Backup to put the temporary table on tape.
6. Create a catalog on the backup system to correspond to the temporary catalog on
the primary system.
7. Create the schema on the backup system using the same schema name and the
same subvolume name as the schema for the temporary database.
8. Use RESTORE to place the temporary objects on the backup system, specifying
the temporary catalog on the backup system as the target. See Step 5 of Creating
a NonStop SQL/MX Backup Database From an Existing Primary Database for
details.
9. For the backup partition you want synchronized, delete all rows in that partition as
follows:
DELETE FROM name
WHERE key-column >= 'F' and key-column < 'K';
10. Now load only the rows from the temporary partition that you want synchronized
into your backup table's partition, as follows:
INSERT INTO backup-table SELECT * FROM temporary-table
WHERE key-column >= 'F' AND key-column < 'K';
Backup Partition Does Not Already Exist
If a partition does not already exist on the backup system, you must create a partition
on the the backup system. See Creating a NonStop SQL/MX Backup Database From
an Existing Primary Database for how to do this. Then you must insert the rows into
the backup partition using either of the two methods described above. In this case you
do not need to delete the rows from the backup partition because it is already empty.