Commitment Control

Versions supported—CDC Replication Engine for Db2 for i version 6.1 and later

Enabling commitment control maintains transaction consistency during replication and ensures that all transactions are applied to the target system. If there is a communications or server failure, and you have enabled this system parameter, then the CDC Replication Engine for Db2 for i rolls back the partially applied transaction to the last commit.

Applies to

Target datastores

Values

Set this parameter to one of the following value:

*NONE

Disables commitment control for transaction processing. the CDC Replication Engine for Db2 for i does not maintain transaction consistency during replication.

To ensure consistency across different platforms and previous releases of the CDC Replication Engine for Db2 for i, disabling commitment control is the default setting for this parameter.

*LEVEL1

Enables the CDC Replication Engine for Db2 for i to use commitment control against the target system after applying all rows.

This setting provides true transaction consistency by ensuring that entire transactions are committed to the target database even in the event of a communications or server failure.

Default Setting

*NONE