RDF System Management Manual

Installing and Configuring RDF
HP NonStop RDF System Management Manual—524388-003
3-6
Synchronizing the Primary and Backup Databases
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/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 NonStop SQL/MP catalog updating:
CREATE CATALOG \BACK.$DATA1.DBCAT;
2. Set up DEFINEs on the primary system to simplify referring to NonStop 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;
4. Enter a CREATE TABLE command to create the partitioned table:
CREATE TABLE =EMPLOYEE (
EMPNUM DECIMAL (5) UNSIGNED NO DEFAULT,
FIRST_NAME CHARACTER(15) NO DEFAULT,
LAST_NAME CHARACTER(20) NO DEFAULT,
PRIMARY KEY EMPNUM )
ORGANIZATION KEY SEQUENCED
PARTITION ( =EMPLPAR2 FIRST KEY 3000 );
This command creates an audited table with AUDITCOMPRESS on.
5. Enter CREATE CONSTRAINT commands for any constraints that values in
particular columns of the table must satisfy:
CREATE CONSTRAINT EMPNUM_CONSTRNT
ON =EMPLOYEE
CHECK EMPNUM BETWEEN 1 AND 99999;
6. Create the index for the NonStop SQL/MP table on the primary system:
CREATE INDEX =EMPLNAME
ON =EMPLOYEE( LAST_NAME, FIRST_NAME );