RDF/IMP and IMPX System Management Manual (RDF 1.4+)

Installing and Configuring RDF
HP NonStop RDF/IMP and IMPX System Management Manual—524388-001
3-5
Synchronizing the Primary and Backup Databases
1. Place the database creation commands in either an EDIT (command) file or TACL
macro or routine. See the HP NonStop TACL Reference Manual for more
information.
2. Through the TACL command interpreter, issue an OBEY filename command or run
the macro to create the primary database.
3. Copy the command file or TACL macro to the backup system.
Now do the following on the backup system:
•
Change any system references in the command file or TACL macro from the
primary system name to the backup system name. If the volume names are
different or if you want a different database layout on the backup system, change
volume references as well.
•
Through the TACL command interpreter, issue an OBEY filename command or run
the macro to create the backup database.
Synchronizing Databases With SQLCI Commands
You can use SQLCI commands to synchronize NonStop SQL or Enscribe databases
online. For NonStop SQL databases, you create the catalog or catalogs on the backup
system and then duplicate the objects registered in each catalog. For Enscribe
databases, you duplicate the database files.
For complete information about using SQLCI to copy databases, see the information
on moving databases in the HP NonStop SQL Installation and Management Guide. For
the syntax of SQLCI commands, see the SQLCI online help or the HP NonStop SQL
Reference Manual.
The following example shows how you can create a partitioned NonStop SQL table
with an alternate index on the primary system with the SQLCI CREATE command, and
then duplicate this table on the backup system by using the SQLCI DUP command. In
this example, \PRIM is the primary system and \BACK is the backup system.
Notice that the catalog for this NonStop SQL table is created on the backup system
before starting RDF on the primary system so that RDF will recognize the backup
catalog and not report errors when attempting to process audit data for this catalog.
1. Using SQLCI, enter a CREATE command to create the catalog on the backup
system. TMF must be up for NonStop SQL catalog updating:
CREATE CATALOG \BACK.$DATA1.DBCAT;
2. Set up DEFINEs on the primary system to simplify referring to NonStop SQL tables
in subsequent SQLCI commands for the primary system:
SET DEFMODE ON;
ADD DEFINE =EMPLOYEE, CLASS MAP,
FILE \PRIM.$DATA1.DB.EMPLOYEE;
ADD DEFINE =EMPLPAR2, CLASS MAP,
FILE \PRIM.$DATA2.DB.EMPLOYEE;