Increase the speed of consistency checking

You can increase the speed of checking the consistency of replicates or replicate sets with the cdr check replicate or cdr check replicateset commands in several ways.

About this task

To increase the speed of consistency checking of replicate sets by checking the member replicates in parallel, use the --process option to set the number of parallel processes equal to the number of replicates.

To increase the speed of consistency checking by limiting the amount of data that is checked, use one or more of the following options:

  • Skip the checking of large objects with the --skipLOB option. If you find that your large objects do not change as much as other types of data, then skipping them can make a consistency check quicker.
  • Check from a specific time with the --since option. If the replicate uses the time stamp or delete wins conflict resolution rule and you regularly check consistency, you can limit the data that is checked to the data that was updated since the last consistency check.
  • When checking a replicate, you can check a subset of the data with the --where option.

If you have large tables, you can index the ifx_replcheck shadow column.