The DISABLE_PARTITIONS statement controls whether PowerExchange disables partitioning of the source data for bulk data movement operations.
All
Offloaded DB2 unload, sequential, and VSAM data sets
No
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.
Default is N.
Use the DISABLE_PARTITIONS statement to preserve existing behavior when upgrading from a PowerExchange release earlier than 9.0 to 9.0 or later. The statement provides backward compatibility in special cases. For more information, see the