DB2 Replication Guide and Reference

Cloning a Replication Subscription to Another Server

You can clone a replication subscription to another server. Cloning creates an exact copy of an existing replication subscription on a different target server, using a different Apply qualifier. You can clone one or more replication subscriptions at a time. The Control Center updates the control tables at the control server.

To clone a replication subscription:

1. Select the Replication Subscriptions folder from the object tree. The replication subscriptions appear in the contents pane.

2. In the contents pane, select the replication subscription object that you want to modify and select Clone from the pop-up menu. The Clone window opens.

3. Specify a new Apply qualifier in the Apply qualifier field. This value can be an ordinary or delimited identifier.

4. Specify the new target server in the Target server field. This value can be an ordinary or delimited identifier.

5. Click on OK to save the values and close the window. The Subscription Information window opens.

6. To specify the control server database, enter the database name in the Specify database to store subscription control information field.

7. Specify whether to submit the replication request now or save the SQL statements generated by the action in a file to be run later. See Customizing and Running Replication SQL Files to learn how to submit the request now or later.

8. After you submit the request, verify that the replication subscription was cloned by selecting the Replication Subscription folder in the object tree and selecting the Refresh menu choice. Check the Apply qualifier and target server name for the replication subscription.

[ DB2 List of Books | Search the DB2 Books ]