Replication Server set autocorrection Command

The Replication Server set autocorrection command prevents failures that would otherwise be caused by missing or duplicate rows in a replicated table.

The set autocorrection command corrects discrepancies that may occur during materialization by converting each update or insert operation into a delete followed by an insert.

You can set autocorrection from Replication Agent for one or all marked tables in the primary database by using the ra_set_autocorrection command as described in the Replication Agent Reference Manual. To set autocorrection from Replication Server, use the set autocorrection command in a replication definition. You must do this from Replication Server because Replication Agent cannot alter the autocorrection setting on a replication definition. See the Replication Server Administration Guide.