Autocorrection for Nonatomic Materialization

To enable autocorrection, issue the set autocorrection command with the on option for each replication definition to which you plan to subscribe using nonatomic materialization. .

When using autocorrection, if Replication Server updates or inserts a row in a primary table, it converts the update or insert into a delete followed by an insert, so that the update or insert operation cannot fail because of an existing row.

During nonatomic subscription materialization, Replication Server selects data without a holdlock. After adding the data to the replicate database, Replication Server applies replicated commands. If you enable autocorrection, Replication Server corrects certain temporary inconsistencies that may be caused by selecting the data using the without holdlock option.

However, if you execute replicated stored procedures that change subscription data during materialization, autocorrection does not always correct the replicate database. During function calls, autocorrection does not protect against inconsistencies.

After a subscription that uses nonatomic materialization has materialized, you can disable autocorrection for better performance. If you disable autocorrection, you can also specify minimal column replication.

See Replication Server Reference Manual > Replication Server Commands > set autocorrection.

Related concepts
Replicate the Minimal Set of Columns