Scenario 1

• Adaptive Server text, unitext, image, and rawobject status: replicate_if_changed

• Replication text, unitext, image, and rawobject definition status: always_replicate

When RepAgent shuts down because a text, unitext, image, or rawobject column has a status of replicate_if_changed at the Adaptive Server database and always_replicate in the replication definition, take the following steps to resolve inconsistencies:

To replicate text, unitext, image, or rawobject columns only when their values change:

1. Execute the alter replication definition command and change the status of the text, unitext, image, or rawobject columns to replicate_if_changed. Wait for the modified replication definition to arrive at the replicate sites.

2. Restart RepAgent.

To always replicate text, unitext, image, or rawobject columns:

1. Stop updates at the primary table.

2. Execute the alter replication definition command, and change the status of the text, unitext, image, or rawobject columns to replicate_if_changed. Wait for the modified replication definition to arrive at the replicate sites.

3. Restart RepAgent to let transactions with a replicate_if_changed status finish processing.

4. Execute the sp_setrepcol system procedure at the Adaptive Server and change the status to always_replicate.

5. Execute alter replication definition and change the status of the text, unitext, image, or rawobject columns to always_replicate. Wait for the modified replication definition to be replicated to the replicate sites.

6. Resume updates to the primary table.