This example uses the

Minimum Rows Per commit

and

UOW Count

attributes to control target commit processing. The change data consists of UOWs of the same size. Each UOW contains ten change records. The commit control attributes have the following values:

PWXPC passes the minimum number of rows value to PowerExchange and requests change data from the change stream. Because the minimum rows value is 100, PowerExchange skips commit records in the first 9 UOWs. When PowerExchange reads the last change record in the tenth UOW, the minimum rows limit is met. PowerExchange then passes the commit record for the tenth UOW to PWXPC and resets the minimum rows counter. PWXPC increases the UOW counter to 1.

PowerExchange and PWXPC continue to read the change data until the UOW counter is 10. At this point, PWXPC flushes the data buffer to commit change data to the targets and resets the UOW counter.

In this example, PWXPC commits change data after 1,000 change records. This frequency is equivalent to after every 10 UOWs because each UOW contains 100 change records and the

UOW Count

is 10.