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.

In version 15.7.1 SP200, by default, Replication Agent autocorrects tables marked for replication when the ra_autocorrect_on_mark configuration parameter value is set to true. In earlier versions, 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.