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 1. Subpacket Commit and UOW Count

Example 1. Subpacket Commit and UOW Count

This example uses the
Maximum 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 1,000 change records. The commit control attributes have the following values:
  • Maximum Rows Per commit
    is set to 300.
  • Minimum Rows Per commit
    is set to 0, which disables this attribute.
  • Real-time Flush Latency in milli-seconds
    is set to 0, which causes 2 seconds to be used.
  • UOW Count
    is set to 1.
Based on the maximum rows value, PWXPC flushes the data buffer after reading the first 300 records in a UOW. This action commits the change data to the targets. PWXPC continues to commit change data to the targets every 300 records.
PWXPC commits change data on UOW boundaries only for the UOW count and real-time flush latency interval. If the real-time flush latency interval expires before PWXPC reads 300 change records, PWXPC still commits change data based on the maximum rows value because that threshold is met before a UOW boundary occurs.
When the end of the UOW is read, PWXPC commits the change data because the
UOW Count
value is 1. PWXPC resets the UOW and maximum rows counters and the real-time flush latency timer each time PWXPC issues a commit. Because all of the UOWs have the same number of change records, PWXPC continues to read change data and commit change data to the targets at the same points in each UOW.
In this example, PWXPC commits change data at the following points:
  • 300 change records based on the maximum rows value
  • 600 change records based on the maximum rows value
  • 900 change records based on the maximum rows value
  • 1,000 change records based on the UOW count value

0 COMMENTS

We’d like to hear from you!