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

Installing and Configuring RDF
Compaq NonStop™ RDF/IMP and IMPX System Management Manual—522204-001
3-5
Synchronizing the Primary and Backup Databases
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 SQL/MP or Enscribe databases online.
For SQL/MP 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 NonStop™ SQL/MP Installation and Management Guide. For
the syntax of SQLCI commands, see the SQLCI online help or the NonStop™ SQL/MP
Reference Manual.
The following example shows how you can create a partitioned SQL/MP 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 SQL/MP 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 SQL/MP catalog updating:
CREATE CATALOG \BACK.$DATA1.DBCAT;
2. Set up DEFINEs on the primary system to simplify referring to SQL/MP 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;
ADD DEFINE =EMPLNAME, CLASS MAP,
FILE \PRIM.$DATA2.DB.EMPLNAME;
3. Create the catalog on your primary system and make this the default catalog for all
partitions:
CREATE CATALOG \PRIM.$TEST.DBCAT;
CATALOG \PRIM.$TEST.DBCAT;