Table of Contents

Search

  1. Preface
  2. Part 1: Introduction
  3. Part 2: PowerExchange Client for PowerCenter (PWXPC)
  4. Part 3: PowerExchange ODBC
  5. Appendix A: PowerExchange Interfaces for PowerCenter Tips
  6. Appendix B: Datatypes and Code Pages
  7. Appendix C: PowerExchange Interfaces for PowerCenter Troubleshooting

PowerExchange Interfaces for PowerCenter

PowerExchange Interfaces for PowerCenter

Example 2. UOW Count and Time-Based Commits

Example 2. UOW Count and Time-Based Commits

This example uses the
UOW Count
and
Real-time Flush Latency in milli-seconds
attributes to control commit processing. The change data consists of UOWs of varying sizes. The commit control attributes have the following values:
  • Maximum Rows Per commit
    is set to 0, which disables this attribute.
  • Minimum Rows Per commit
    is set to 0, which disables this attribute.
  • Real-time Flush Latency in milli-seconds
    is set to 5000, which is equivalent to 5 seconds.
  • UOW Count
    is set to 1000.
Initially, PWXPC reads 900 complete UOWs in 5 seconds. At that point, the real-time flush latency interval has expired. As a result, PWXPC flushes the data buffer to commit change data to the targets. PWXPC then resets both the UOW counter and real-time flush latency timer. When PWXPC reaches the thousandth UOW, PWXPC does not commit change data to the targets because the UOW counter was reset to 0 after the last commit.
PWXPC reads the next 1,000 UOWs in 4 seconds, which is less than the real-time flush latency timer. PWXPC commits this change data to the target because the UOW counter has been met. PWXPC then resets the real-time flush latency timer and the UOW counter.
PWXPC continues to read change data and commit change data to the targets based on the UOW count or real-time flush latency limit, whichever is met first.
In this example, PWXPC commits change data at the following points:
  • After UOW 900 because the real-time latency flush latency timer was met first.
  • After UOW 1,900 because the UOW count was met first during the second commit cycle.

0 COMMENTS

We’d like to hear from you!