Checking and repairing a replicate

Run a consistency check to compare the data between a reference server and one or more target servers in a replicate, generate a report that describes any inconsistencies, and repair the inconsistent rows so that they match the rows on the reference server.

To check and repair a replicate:

  1. On the menu of the HCL OpenAdmin Tool (OAT) for Informix®, expand Replication, and then click Replicates.
  2. Click the Replicates tab.
  3. Click the replicate in the table. To view the participants, expand the replicate name.
  4. On the Actions menu, click Check or Sync Replicate.
  5. Enter a name to identify the task so that you can monitor it on the Task Status page.
  6. Select Check and Repair.
  7. Optional: For a replicate that uses the time stamp or delete wins conflict resolution rule, select the option to repair inconsistencies based on the latest time stamp. This option requires HCL Informix version 11.70.
  8. For Frequency, specify when to perform the action. The default is Immediately, when you click Finish.
  9. Optional: Select the options to limit the number of rows to check by time period or with a WHERE clause.
  10. Select a Reference server to use as the reference copy of the data. The list displays the servers that are participants in the replicate.
  11. Specify how to handle rows on the target servers that are not on the reference server. The default is Delete: Remove the extra rows from the target servers.
  12. Specify how to handle triggers at the target servers while repairing the data. The default is Off: Do not fire triggers at target servers during synchronization.
  13. Specify the target servers to check and repair.

    To monitor the progress of the task and to see the consistency report, click the Task Status tab.

Copyright© 2018 HCL Technologies Limited