Committing Other Transactions Before Starting a Long-running Transaction
This use of EVENTACTIONS
ensures that all open transactions that are being processed by Replicat get committed to the target before the start of a long running transaction. It forces Replicat to write a checkpoint before beginning work on the large transaction. Forcing a checkpoint constrains any potential recovery to just the long running transaction. Because a Replicat checkpoint implies a commit to the database, it frees any outstanding locks and makes the pending changes visible to other sessions.
TABLE source.batch_table, EVENTACTIONS (CHECKPOINT BEFORE);