Performing a Repair Job

Repair jobs are named background processes that synchronize two database 4servers for a specific replicate or replicate set.

Repair jobs can be 4run online while replication is active. First, you create the repair job using 4the cdr define repair command. Then, run the job using 4the cdr start repair command.

You can define a repair job for a single replicate or for a replicate set. 4When you repair a replicate set, Enterprise Replication synchronizes tables 4in an order that preserves referential integrity constraints (for example, 4child tables are synchronized after parent tables).

3During the execution of the repair process, lock contention 3is possible. The repair process performs dummy updates on a block of rows 3at a time, however, the whole table is not locked.4

3Transaction log consumption increases during a repair process 3due to operations on repair control tables as well as dummy updates on the 3user table.4

The following restrictions apply to running repair jobs:

4
• The Enterprise Replication network connection must be active between the 4Connect server, reference server and the target servers while performing a 4repair job.
4
• The replicate must not be in a suspended or stopped state when you start 4a repair job or while the job is running.
4
• The replicate must not be set up for time based replication.

If a repair job cannot repair a row, the inconsistent row is recorded in 4an ATS or RIS file. For more information, see Repairing Failed Transactions with ATS and RIS Files.

Filtering a Repair Job

If you have a situation where 4just part of the table needs to be repaired, for example when one fragment 4in a partitioned table has incorrect data, you can use the --filter (-f) option of the cdr 4define repair command. With the --filter option 4you specify a WHERE clause for the source participant and a WHERE clause for 4the target participant that restrict the columns for which the repair job 4runs.

Stopping Repair Jobs

You can stop a repair job using the cdr stop repair command. You can restart from where it left off by running the cdr start repair command again. If you have defined a new repair job 4of the same name, the new job is started from the beginning. The old, partially 4run job is not started again.

Viewing Information About Repair Jobs

You can view information about 4repair jobs by using the cdr list repair command.

Deleting Repair Jobs

Repair job definitions are 4not automatically removed from the global catalog; delete them using the cdr delete repair command.