Replicating full rows or changed columns

Modify a replicate to specify whether to replicate full rows or only changed columns.

Prerequisite: With the Modify Replicate action, you can modify a strict master replicate and its participants. A master replicate verifies that replicated tables on different servers have consistent column data types. A strict master replicate also verifies that the replicated tables have identical column names.

By default, Enterprise Replication (ER) replicates the full row and enables upserts, even if only one column changes. However, columns containing BLOB or CLOB data are updated only when their contents have changed, regardless of whether other columns have changed or not.

To specify whether to replicate full rows or changed columns:

On the menu of the HCL OpenAdmin Tool (OAT) for Informix®, expand Replication, and then click Replicates.
Click the Replicates tab.
On the Actions menu, click Modify Replicate.
The list displays the server groups in the domain with the participants in bold.
Click Next.
Specify whether to replicate full rows:
- To replicate the full rows and enable upserts, select Replicate full row. If you also specify delete wins as the conflict resolution rule, upserts are disabled.
- To replicate only changed columns and disable upserts, clear this option.
To modify the replicate, click Finish.
The options that you selected and the results of the action are displayed.