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 IBM_USE_DB2_SYSTEM_OBJECT_NAMES statement controls whether PowerExchange searches both IBM i system object names and SQL object names or only SQL object names for Db2 for i source objects when you create PowerExchange capture registrations in the PowerExchange Navigator or the DTLUCBRG utility or perform database row tests in the PowerExchange Navigator.
Use this statement if you are more familiar with system object names than with SQL object names or if some source tables were renamed causing the system_table_name and table_name column identifiers in the SYSTABLES table to be different.
Object names
include names of schemas and tables.
  • Y
    . Search both Db2 system object names and SQL object names when creating capture registrations.
  • N
    . Search only SQL object names.
Default is
Do not change this setting after you have created active Db2 for i capture registrations.


We’d like to hear from you!