The following table describes the optional

Minimum Rows Per commit

connection attribute:

If the change stream contains many small UOWs, you can use the

Minimum Rows Per commit

attribute to create larger UOWs of a more uniform size.

This attribute specifies the minimum number of change records that the PowerExchange Listener must read from the change stream before it passes a commit request to PWXPC. Until the minimum rows limit is met, the PowerExchange Listener discards any commit records that it reads from the change stream and passes only change records to PWXPC. After the minimum rows limit is met, PowerExchange passes the next commit record to PWXPC and then resets the minimum rows counter.

Online transactions that run in transaction control systems such as CICS and IMS often issue a commit after making only a few changes, which results in many, small UOWs in the change stream. PowerExchange and PWXPC can process fewer, larger UOWs more efficiently. Therefore, by using this attribute to increase the size of UOWs, you can improve CDC processing efficiency.

A minimum rows limit does not damage the referential integrity of the change data because PowerExchange does not create new commit points in the change stream. PowerExchange only skips some of the original commit records in the change stream.