Repairing failed transactions with RIS files

Repair failed transactions by using Row Information Spooling (RIS) files. The RIS repair task reconciles rows that failed to be applied on the target server.

Prerequisite: Create a directory to store the RIS files, enable RIS file generation on the Enterprise Replication (ER) server, and activate RIS file generation for the replicate.

An RIS file is generated when a replicated transaction that has row scope defined fails to be applied to the target database because of a conflict, and the entire transaction fails. When you repair the transaction by using the RIS file, you repair the row that is recorded in the RIS file.

To repair transactions by using RIS files:

  1. On the menu of the HCL OpenAdmin Tool (OAT) for Informix®, expand Replication, and then click Replicates.
  2. Click the RIS tab.
  3. In the Row Information Spooling (RIS) table, select the check boxes for the RIS files.

    If you do not repair all the available RIS files at the same time, some repair tasks might fail because of problems maintaining the relationships between the tables (referential integrity constraints).

  4. Click Repair.
  5. Review the RIS files that you selected for repair.

    To see the details of an RIS file, click the name of the file.

  6. Click Repair.
  7. Monitor the progress of the task and review the results in the RIS Repair Task Status list.

    To display the details of a task, click the file name in the list.

Copyright© 2018 HCL Technologies Limited