Specifies whether to use offload processing to move PowerExchange bulk data processing from the source or target system to the PowerCenter Integration Service.

For data sources, select one of the following values:

For data targets, select one of the following values:

Default is No.

When offload processing is enabled, specifies the number of threads that PowerExchange uses on the Integration Service machine to process bulk data.

For optimal performance, assign a value that is equal to or less than the number of installed or available processors on the PowerCenter Integration Service machine.

Valid values are 1 through 64. Default is 0, which disables multithreading.

For VSAM data sets or sequential files, if the

Worker Threads

value is greater than zero, the size of the storage array, in number of records, for the threads.

For DB2 for z/OS image copies, determines the maximum number of memory buffers that might need to be allocated. If zIIP processing is enabled,

Array Size

also specifies how many compressed rows to dispatch to the zIIP processor.

Valid values are 25 through 5000. Default is 25.

Informatica recommends that you use the default value unless you are able to test and quantify whether the extra memory that is allocated to a larger array size has been beneficial and has not degraded server performance. If you are able to make these determinations, Informatica recommends an array size of 500 to 1000 when you enable offload multithreaded processing.

Specifies whether to use bulk data offload processing to move column-level processing for DB2 data from the source system to the PowerCenter Integration Service machine.

Select one of the following values:

Default is No.

When offload processing is enabled, specifies the number of threads that PowerExchange uses on the Integration Service machine to process bulk data.

For optimal performance, this value should not exceed the number of installed or available processors on the Integration Service machine.

Valid values are 1 through 64. Default is 0, which disables multithreading.

Specifies the DB2 fetch array size. For more information about DB2 fetch array sizes, see the IBM DB2 documentation.

Valid values are 1 through 100000. Default is 25.

Informatica recommends that you use the default value unless you are able to test and quantify whether the extra memory that is allocated to a larger array size has been beneficial and has not degraded server performance. If you are able to make these determinations, Informatica recommends an array size of 500 to 1000 when you enable offload and multithreaded processing.