Replication Guide and Reference

Loading target tables offline using DJRA

DJRA guides you through the process of creating an offline load of a table or database. The following procedure does not maintain the additional control information required for loading external CCD tables, so for these tables you must use the manual procedure.

To perform an offline load using DJRA:

1. Ensure that the Capture program is running.

2. Click Off-line load on the DJRA main window.

3. In the Off-line load -- STEP 1 window, generate the SQL statements to disable current subscriptions for the selected subscription sets. After you load the target tables, you will re-enable these subscriptions.

4. Unload the source tables. Then click Next Step on the Off-line load -- STEP 2 window.

5. Load the target tables. Then click Next Step on the Off-line load -- STEP 3 window.

6. In the Off-line load -- STEP 4 window, generate the SQL statements to re-enable current subscriptions for the selected subscription sets. Then click Finished.

[ DB2 List of Books | Search the DB2 Books ]