RDF System Management Manual

Table Of Contents
NonStop SQL/MX and RDF
HP NonStop RDF System Management Manual524388-003
15-8
Online Database Synchronization With NonStop
SQL/MX Objects
For example, assume you have the objects on your primary system that have the
following fully qualified Guardian names:
\pnode.$DATA01.ZSDABCDEF.FILE100
\pnode.$DATA02.ZSDABCDEF.FILE100
\pnode.$DATA03.ZSDABCDEF.FILE100
For the RESTORE command, you must name the qualified Guardian filenames of
your source objects and also the qualified Guardian filenames of your target
objects in the LOCATION clause.
LOCATION
( \pnode.$DATA01.ZSDABCDEF.FILE100 TO \bnode.$DATA0A.ZSDABCDEF.FILE100,
\pnode.$DATA02.ZSDABCDEF.FILE100 TO \bnode.$DATA0B.ZSDABCDEF.FILE100,
\pnode.$DATA03.ZSDABCDEF.FILE100 TO \bnode.$DATA0C.ZSDABCDEF.FILE100
)
Note that the volume names can differ between the primary and backup systems.
Also, the subvolume and filenames on the backup system must be identical to
those on the primary system, and the the subvolume must correspond to the
subvolume you used when you created your schema.
The backup database is now ready for RDF replication activity.
Online Database Synchronization With
NonStop SQL/MX Objects
The principles of protocol for online database synchronization with NonStop SQL/MX
objects are the same as for Enscribe and NonStop SQL/MP objects. That is, you follow
the guidelines for the RDF online database-synchronization protocol. The only
difference is how the fuzzy copy is obtained. The following discussions focus on the
two options for getting the fuzzy copy: creating a fuzzy copy on the primary system or
creating the fuzzy copy on the backup system.
Creating the Fuzzy Copy on the Primary System
The advantage of this method is that in creating and populating the fuzzy copy on the
primary system you achieve better performance than by creating and populating the
fuzzy copy over the network. Once created and populated, you use
BACKUP/RESTORE to move the fuzzy copy to the backup system. The disadvantage
of this method is that it requires disk space on the primary system to store a second
copy of your NonStop SQL/MX database.
To create the fuzzy copy on the primary system, perform the following steps.
1. Create a temporary catalog on your primary system to correspond to your regular
catalog on your primary system whose objects you want RDF to replicate.
CREATE CATALOG <catalog_name> LOCATION <optional_guardian_location>;