RDF System Management Manual

Table Of Contents
Online Database Synchronization
HP NonStop RDF System Management Manual524388-003
7-16
Partial Database Synchronization Issues
You must load all the partitions of a relative file. Therefore, only one command is
possible.
FUP LOAD $DATA1.TEST.PART0100, $DATA1.TEMP.PART0100,
SHARE
You can then use BACKUP and RESTORE (or FUP DUP) with the PARTONLY option
to copy the loaded partition you need to the backup system.
Entry-sequenced and Unstructured Files
Currently there is no reliable mechanism to synchronize these file types online. Entry-
sequenced and unstructured files should be synchronized offline.
NonStop SQL/MP Tables Without Partitions
Key-sequenced Tables with SYSKEY
Because the SQLCI LOAD operation generates new SYSKEY values in the backup
table, key-sequenced tables containing SYSKEYs cannot be synchronized online.
Key-sequenced Tables without SYSKEY and Relative Tables
First create a non-audited duplicate table on the primary system and then load it. Use
BACKUP and RESTORE (or SQLCI DUP) to move the duplicate table to the backup
system.
Alternatively, you can use the create and load method to put the duplicate tables
directly onto the backup system, provided you have enough Expand capacity to handle
both the data being loaded and the audit being shipped to the backup system by the
extractor.
There are no special considerations for key-sequenced tables with indexes, but see
below for issues regarding the synchronization of indexes.
NonStop SQL/MP Tables With Partitions
The utilities associated with and related to the NonStop SQL/MP product have
limitations that make synchronization of individual partitions complicated and difficult.
The following represent methods that enable you to circumvent these limitations.
1. SQLCI DUP does not have a PARTONLY option. Therefore, you cannot
duplicate only an individual partition.
2. While BACKUP and RESTORE have the PARTONLY option, if you have backed
up tables from the primary system, you must use the MAP NAMES option when
restoring them on the backup system in order to specify the correct system name.
You cannot, however, include both the MAP NAMES and PARTONLY options in
the RESTORE operation. Therefore, because you must use MAP NAMES, you
cannot restore only a single partition.