Preparing Tables for Conflict Resolution

Home | Previous Page | Next Page Setting Up and Managing Enterprise Replication > Preparing the Replication Environment > Preparing Data for Replication >

Preparing Tables for Conflict Resolution

To use any conflict-resolution rule other than ignore, you must define the shadow columns, cdrserver and cdrtime.

Tip:

If you plan to use only the ignore conflict-resolution rule, you do not need to define the cdrserver and cdrtime shadow columns.

For more information about update-anywhere and conflict resolution, see Update-Anywhere Replication System.

To define the shadow columns in your table, use the following statements:

For new tables, use:
```
CREATE TABLE table_name WITH CRCOLS;
```
For existing tables, use:
```
ALTER TABLE table_name ADD CRCOLS;
```

Important:

If a table already participates in Enterprise Replication, you must stop replication before altering it with the ADD CRCOLS clause. For more information, see Stopping a Replicate.

To drop the cdrserver and cdrtime shadow columns, use:

ALTER TABLE table_name DROP CRCOLS;

Tip:

The ADD CRCOLS and DROP CRCOLS clauses to the ALTER TABLE statement are now processed as in-place alters in most cases. For more information, see the section on in-place alters in the IBM Informix Performance Guide. For more information on CREATE TABLE and ALTER TABLE, see the sections in the IBM Informix Guide to SQL: Syntax.