Recommendations for loading target tables for Q Replication

Here are a few recommendation for making sure that the process goes smoothly:

Applications at the target

Do not allow applications to update the target tables while they are being loaded. Data in the tables will be inconsistent while the tables are being loaded, and the Q Apply program drops referential integrity constraints until the target table and any other related target tables are loaded.

Applications can safely use target tables again when the Q Apply program makes the following changes to the IBMQREP_TARGETS table:

• Sets the STATE column to A (active).
• Sets the STATE_INFO column to ASN7606I, which means that if the target table had referential integrity constraints, they have been restored.

You can use the Manage Q Subscriptions window in the Replication Center to verify that these two changes have been made. To open the window, right-click the Q Capture server where the source table for the Q subscription is located and select Manage > Q Subscriptions.

If the loading process fails, or if the Q Apply program stops during the load, any data that was in the target table before the load began is deleted. Changes that were made to the source table during the load process are not lost, and will be applied to the target table after it is successfully loaded.

Applications at the source

Load target tables during a time of relative inactivity at the source.