acceptable_latency_in_seconds_for_column_organized_tables
Use this system parameter to indicate the maximum acceptable latency for subscriptions involving column-organized tables.
Version—CDC Replication Engine for Db2® Database version 10.2.1 Interim Fix 12 or later
CDC Replication temporarily buffers transactions during replication in order to minimize the impact to the target database when applying to column-organized tables. This buffering can increase latency. If the latency reaches the point indicated by this system parameter CDC Replication will stop buffering the data. Note that CDC Replication will perform this buffering whenever there is at least one column-organized table being targeted in a subscription and that this buffering affects all the tables in the subscription.
- Applies to
- Target datastores
- Minimum Setting
- 1 second
- Maximum Setting
- 2147483647 seconds
- Default Setting
- 5 seconds