mirror_batch_apply_check
Use this system parameter to control the checks that the replication engine performs after applying batched data to the target database.
During mirroring, the CDC Replication Engine for FlexRep batches data to be applied to the destination database. After applying a batch, it relies on the JDBC driver batch metadata to execute certain checks around the batch data that was applied. These checks could degrade performance and some drivers opt to skip such implementations.
- Value
- Acceptable values:
- CHECK_ROWS_AFFECTED - After batch apply is complete, the engine checks each INSERT, UPDATE, or DELETE to ensure that each operation that was applied resulted in one database modification.
- CHECK_ROWS_AFFECTED_UPDATE_DELETE - The engine runs the same checks, but only for UPDATES and DELETES.
- NONE - The engine does not run any checks after batch applied data. Functionality such as conflict detection that relies on such checks might not be able to detect all conflicts when checking is not available. As an alternative to setting mirror_batch_apply_check to NONE, you could disable batching if it is imperative to run the checks.
- Applies to
- Source and target datastores
- Default setting
- CHECK_ROWS_AFFECTED