DB2 Replication Guide and Reference

Removing Replication Subscriptions

When you no longer need a replication subscription definition, or the requirements have changed enough that you need to redefine it, you can remove it. Removing a replication subscription definition deletes information about it from the control tables and deletes the target table from the target server. If you have selected to drop table spaces in the Tools Settings notebook, the table space is also dropped.

You can remove replication subscription definitions that are dependent on replication sources that you are removing. (If you remove a replication source which has dependent replication subscriptions, the dependent subscriptions will be removed automatically.)

To remove a replication subscription:

1. Select one or more replication subscription objects from the contents pane and select Remove from the pop-up menu. The Remove Subscription Confirmation window opens.

2. Click on Yes to save the values and close the window. The Run Now or Save SQL window opens. 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.

3. After you submit the request, verify that the replication subscription was removed by selecting the Replication Subscriptions folder in the object tree and selecting the Refresh menu choice.

[ DB2 List of Books | Search the DB2 Books ]