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

Online Database Synchronization
HP NonStop RDF/IMP and IMPX System Management Manual—524388-001
7-7
Considerations When Synchronizing Entire
Databases
General Considerations for SQL Tables
•
Key-sequenced Tables without SYSKEY. To improve the performance of the
load operations significantly, specify the SORTED option.
•
Key-sequenced Tables with SYSKEY. Because the SQLCI LOAD operation
generates new SYSKEY values, key-sequenced tables containing SYSKEYs
cannot be synchronized online.
•
Relative Tables. To ensure complete consistency with the source files, specify the
NO COMPACT option.
•
Entry-sequenced Tables. Currently there is no reliable mechanism to
synchronize entry-sequenced tables online. These tables should be synchronized
offline.
•
Partitioned Tables. You can initiate the load operation with a single command by
executing the LOAD command against the primary partition.
•
Index Tables. With regard to index tables, there are several considerations for
relative and key-sequenced tables. Regardless of base table type, you cannot
load an index table by itself. Index tables can only be loaded when the associated
relative or key-sequenced table is loaded.
If you want the associated index tables loaded when you load a relative or key-
sequenced table, you must create empty index tables first, before issuing the
LOAD command. When you load the base table, the index tables are loaded
automatically.
Alternatively, you can load your base tables without index tables. Then you can
create and populate your index tables with the SQL product before you start the
RDF updaters.
If you fail to create the index tables before issuing the START UPDATE command,
the affected updater reports a file system error 11 (File not found) when trying to
apply an update to an index table, and it continues to retry the update. In this
situation, the updater does not make forward progress until you create the index on
your backup system.
Enscribe Queue File Issues
For ENSCRIBE queue files, a different method of obtaining the fuzzy copy is required.
You must use the FUP COPY command with the SHARE option specified, and with
“FIRST 1” specified. For example, the following command copies the contents of file
QUEUE1 to QUEUE2.
FUP COPY QUEUE1, QUEUE2, FIRST 1, SHARE