Resynchronizing data among replication servers

Correct data inconsistencies between replicated tables. Check for data inconsistencies, repair inconsistencies during a check, synchronize data, or repair failed transactions with Aborted Transaction Spooling (ATS) and Row Information Spooling (RIS) files.

With the HCL Informix® Replication Plug-in for OpenAdmin Tool (OAT), you can repair data inconsistencies between replicated tables in the following ways:

• Check consistency and repair inconsistent rows: A consistency check compares the data between a reference server and one or more target servers and then generates a report that describes any inconsistencies. You can choose to repair inconsistent rows during a consistency check. You can perform a consistency check and optional synchronization on a single replicate or a replicate set.
• Synchronize data: Synchronization replicates every row in the specified replicate or replicate set from the reference server to all the specified target servers. You can use direct synchronization to populate a new target server or an existing target server that has become severely inconsistent.
• Repair transactions by using ATS or RIS files: A repair using an ATS or RIS file repairs the rows associated with the single transaction that is recorded in the specified ATS or RIS file.