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-12
Backup Partition Does Not Already Exist
3. Create a temporary table in your temporary schema, including all partitions. Note
that the partition ranges must be identical to those of your primary table. Follow the
guidelines outlined in Creating a NonStop SQL/MX Backup Database From an
Existing Primary Database, above, except that you must create the temporary
table on the primary system and on different volumes from those used for your
primary objects.
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.