jdbc_refresh_max_batch_size
Use this system parameter to control the max batch size during refresh.
This parameter controls how many changes CDC can temporarily hold. Once the limit is reached,
those changes are applied to the target in bulk, either through a JDBC batch or a single statement
that affects several rows at once. Since a batch cannot span a transaction, the batch is applied
when the target transaction is committed.
Note: Ensure that the maximum batch size is not bigger than
the one specified in jdbc_refresh_commit_after_max_operations (default:
1000).
- Applies to
- Target datastores
- Default Setting
- 1000 operations