DISABLE_PARTITIONS={
N|Y}

N
.
Enables partitioning of the source data. For offloaded DB2 unload, VSAM, and sequential data sources, if you specify the same or no SQL override for each partition, PowerExchange reads the source data one time and distributes data across the partitions.
Unless you have a specific reason to disable partitioning and read the source data multiple times, use the default of N for the DISABLE_PARTITIONS statement.
Y.
Disables partitioning of the source data for offloaded DB2 unload, sequential, and VSAM data sets, which is the default behavior for PowerExchange releases earlier than 9.0. If you specify the same or no SQL override for each partition, PowerExchange reads the source data multiple times instead of one time. If you set the
Worker Threads
connection attribute to a value greater than 0, PowerExchange uses multiple worker threads for the session.