DB2 Replication Guide and Reference

Viewing or Changing Existing Replication Sources

You can view an existing replication source or, if you selected the Table will be used for update anywhere check box, you can change the conflict detection level defined for the replication source. All other fields and controls are unavailable for changes after you successfully define the replication source.

To view or change the replication source:

If you plan to change the replication source definition, stop or suspend the Capture program. See the Capture and Apply chapter for your platform in this book to learn more about the Capture program.
Select the Replication Sources folder. The replication sources appear in the contents pane.
Select the replication source object you want to view or change from the contents pane and select the Change menu choice from the pop-up menu. The Change Replication Source window opens.
If the table was made available for update-anywhere replication and you want to change the Conflict detection choices, select a radio button for the change.
Select Cancel if you have not changed the replication source definition. Select 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.
To begin capturing changes for the changed replication source, start or reinitialize the Capture program. See the Capture and Apply chapter for your platform in this book to learn more about the Capture program.

Notes for changing the conflict level detection:

If you want to be able to change the conflict detection level, you must have done the following while defining the replication source:

Selected the Define as source check boxes selected for all columns
Selected the Capture before image check boxes for all columns
Optionally selected the Table will be used for update anywhere replication check boxes

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

[ DB2 List of Books | Search the DB2 Books ]