If you use zIIP processing, PowerExchange can dispatch an array of compressed rows to the zIIP processor for expansion. The

Array Size

connection attribute controls the number of rows that are dispatched. In most cases, use the default array size of 25 for optimal efficiency.

PowerExchange supports offload processing for DB2 for z/OS image copy sources in a bulk data movement session. When you use bulk data offload processing, PowerExchange moves column-level processing and source data filtering to the PowerCenter Integration Service machine that runs the bulk data movement session. To enable offload processing for a DB2 for z/OS image copy data source, select

Filter After

for the

Offload Processing

connection attribute.