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.