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



The SHOW_THREAD_PERF statement specifies the number of records that PowerExchange processes before writing statistics messages for sessions that use multithreaded processing or partitioned processing to the PowerExchange message log file or PowerCenter session log.
All CDC sources. For bulk data movement sessions, the following sources: DB2 for z/OS tables, sequential and flat files, and VSAM data sets.
For bulk data movement sessions that use writer partitions, the following targets: VSAM data sets and sequential files.
For the
variable, enter the number of records that PowerExchange must process in a statistics reporting interval before writing messages with statistics that you can use to assess session performance. Valid values are 10000 through 50000000.
For sessions that use multithreading, PowerExchange writes messages PWX-31254 through PWX-31259 to the PowerExchange message log file. For bulk data movement sessions that use reader or writer partitioning, PWXPC writes messages PWX-31261 and PWX-31262 in the PowerCenter session log and PowerExchange message log.
To have PWXPC write statistics messages in the PowerCenter session log, select the
Retrieve PWX log entries
attribute on a PWX CDC application connection or PWX Batch application connection. This attribute is selected by default.


We’d like to hear from you!