Table of Contents


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

PRE861_COMPAT Statement

PRE861_COMPAT Statement

Controls whether PowerExchange automatically attempts to use offload processing.
Beginning in PowerExchange 8.6.1, PowerExchange automatically enables offload processing, provided that you use the PRE861_COMPAT=N statement that is supplied in the sample DBMOVER configuration file. For PowerExchange 8.6.1 or later, ensure that PRE861_COMPAT is set to N.
If you use a PowerExchange version earlier than 8.6.1, use PRE861_COMPAT=Y for backwards compatibility with earlier offload processing behavior.
Depends on the PowerExchange version
  • N
    . Use this value for PowerExchange 8.6.1 and later. With this value, if you select
    for the
    Offload Processing
    attribute on PWXPC connections, PowerExchange uses offload processing if possible. Also, PowerExchange ignores the
    Offload Processing
    option specified in VSAM and sequential data maps for previous releases.
  • Y
    . Use this value only for PowerExchange versions earlier than 8.6.1. With this value, PowerExchange uses offload processing if you enable it. To enable offload processing for PWX DB2zOS relational connections or PWX CDC Real Time application connections, select
    for the
    Offload Processing
    attribute. For PWX NRDB Batch application connections, select either
    Filter Before
    Filter After
    for the
    Offload Processing
    If you use multiple types of PowerExchange data sources on different platforms, PowerCenter data previews and CDC sessions that use PWX connections might terminate with a connection error. To prevent this problem, define a CAPI_SRC_DEFAULT statement for each source type in the DBMOVER configuration file.
Default is Y.


We’d like to hear from you!