RDF/IMP, IMPX, and ZLT System Management Manual

Installing and Configuring RDF
HP NonStop RDF/IMP, IMPX, and ZLT System Management Manual—524388-002
3-6
Synchronizing the Primary and Backup Databases
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 );
7. Enter commands to specify the data to be inserted into the table on the primary
system:
INSERT INTO =EMPLOYEE ( EMPNUM, FIRST_NAME, LAST_NAME )
VALUES ( 826, "Evans", "Joan" );
INSERT INTO =EMPLOYEE ( EMPNUM, FIRST_NAME, LAST_NAME )
VALUES ( 3351, "MacArthur", "Bill" );
INSERT INTO =EMPLOYEE ( EMPNUM, FIRST_NAME, LAST_NAME )
VALUES ( 10809, "Gember", "Tom" );