Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange
  3. DBMOVER Configuration File
  4. Netport Jobs
  5. PowerExchange Message Logs and Destination Overrides
  6. SMF Statistics Logging
  7. PowerExchange Security
  8. Secure Sockets Layer Support
  9. PowerExchange Alternative Network Security
  10. PowerExchange Nonrelational SQL
  11. PowerExchange Globalization
  12. Using the PowerExchange ODBC Drivers
  13. PowerExchange Datatypes and Conversion Matrix
  14. DTL__CAPXTIMESTAMP Time Stamps
  15. PowerExchange Glossary

DISABLE_PARTITIONS Statement

DISABLE_PARTITIONS Statement

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
PowerExchange Installation and Upgrade Guide
.