Multithreaded processing can help improve performance for CDC sessions in specific situations.
Use the following rule and guidelines to determine when multithreaded processing is useful and how to set the
Worker Threads
attribute:
Use multithreaded processing when the PWX reader thread of a CDC session uses 100% of a single CPU on a multiple-CPU server on the PowerCenter Integration Service machine. In this situation, multithreading improves throughput by spreading PowerExchange processing across multiple threads. Otherwise, multithreading does not improve throughput.
For optimal performance, verify that the value of the
Worker Threads
attribute does not exceed the number of installed or available processors on the PowerCenter Integration Service machine.
When defining the PWX CDC application connection, you must either set the
Location
attribute to "local" to enable the extraction to access the source locally, or set the
Offload Processing
attribute to
Yes
to offload extraction processing.
If processing slows or hangs for CDC sessions that use multiple worker threads, increase the MAXTASKS value in the DBMOVER configuration file to help improve performance.