Replication Guide and Reference

Viewing or Changing an Existing Replication Subscription

You can change a subset of the replication subscription values, primarily those that do not affect the structure of the target tables.

To change the 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 Change from the pop-up menu. The Change Subscription Definition window opens.

3. You can change the following values in the Change Subscription window and subwindows:

   • The Row predicate in the Advanced Subscription notebook. The new predicate is not applied to existing rows in the target table. The predicate is used starting with the next subscription cycle for the replication subscription. See "Defining the Target Table Rows" for more information and examples.

   • The SQL or CALL procedure for before or after copying in the SQL window. See "Defining SQL Statements or CALL Procedures for the Replication Subscription" for more information.

   • The timing values in the Subscription Timing notebook. See "Setting the Copying Schedule: Time or Event Based" for more information.

   • The data blocking value in the Subscription Timing notebook. See "Specifying Mini-Cycles for the Apply Program to Copy Committed Data" for more information.

4. Click on OK 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.

[ DB2 List of Books | Search the DB2 Books ]