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-6
Synchronizing the Primary and Backup Databases
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 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" );
Now direct your attention to the backup system (\BACK). As you perform the
necessary tasks on this system, note the following considerations:
•
DEFINEs cannot be used if you specify MAP NAMES option in the DUP
command.
•
The DUP operation moves the entire database, including all partitions and
indexes, by default.
•
The catalog \BACK.$DATA1.DBCAT is used for all partitions and all indexes.
8. Specify the catalog for the backup system:
CATALOG \BACK.$DATA1.DBCAT;