refresh_commit_after_max_operations
Use this system parameter to identify the number of rows comprising each transaction during refresh.
Versions supported—CDC Replication Engine for Informix® version 6.3.x, version 6.5.0 and version 6.5.1
To reduce the workload on the target database during refresh, CDC Replication periodically commits the changes to the target database rather than performing the refresh as a single large transaction.
- Applies to
- Target datastores
- Minimum Setting
- 1
- Maximum Setting
- 2147483647
- Default Setting
- 1000