IBM Books

DB2 Replication Guide and Reference

Removing Replication Sources

When you no longer need a replication source, you can remove the object from the Control Center and its control information from the control tables.

Attention:

  1. Do not delete a replication source while the Capture program is running.

  2. Although the Control Center removes dependent subscriptions, it is recommended that you check whether a dependent subscription table is being used as a source for another subscription and that you cancel any such dependent subscription before you delete a replication source.

The Control Center drops the replication source table space if it is empty. You can change this default behavior on the Replication page of the Tools Settings notebook so that the table space is not dropped.

To remove a replication source:

  1. Stop the Capture program. See the Capture and Apply chapter for your platform in this book to learn how to stop the Capture program.
    Attention:Do not use the SUSPEND command.

  2. Select the Replication Sources folder. The replication sources appear in the contents pane.

  3. Select one or more replication source objects that you want to delete and select Remove from the pop-up menu.

    A confirmation window prompts you to confirm that you want to remove the replication sources.

  4. Select Yes in the confirmation window to delete the replication sources. 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.
    Attention:Before running the deferred remove request, first stop the Capture program.

  5. After you submit the request, verify that the replication sources were deleted by selecting the Replication Sources folder in the object tree and selecting the Refresh menu choice.

  6. Restart the Capture program. See the Capture and Apply chapter for you platform in this book to learn how to restart the Capture program.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]