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

Db2 for IBM i DBMOVER Statements

Db2 for IBM i DBMOVER Statements

You can include DBMOVER statements specific to Db2 for IBM i data sources.
The following table briefly defines the DBMOVER statements specific to Db2 for IBM i (formerly i5/OS) data sources and provides cross-references to the complete description of the statements:
Specifies an event message queue on an i5/OS system to which PowerExchange writes messages that do not require an operator reply.
Specifies two-character journal entry type codes that identify add library and delete library operations in a DB2 for i5/OS journal. Use this statement to override the default codes that are used for refreshing the CDC library interest list after adding or deleting libraries that contain instances of the same source table.
Specifies the message queue on an i5/OS system to which PowerExchange writes messages that require an operator reply.
Specifies the Consumer API (CAPI) parameters needed for DB2 for i5/OS CDC sources.
Controls whether PowerExchange considers data in CHAR and VARCHAR columns that you define with the FOR BIT DATA clause as character data.
Defines the single-byte and multibyte CCSID values that PowerExchange uses to process character data in columns that you define with the FOR BIT DATA clause, if you specify Y for the DB2_BIN_AS_CHAR statement.
Specifies the name of the user-customized SQL error file that PowerExchange uses for DB2 bulk data movement operations.
Suppresses spool file creation for PowerExchange tasks.
Controls whether to use Db2 system column names when performing PowerExchange database row tests and PowerExchange CDC registrations.
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 or perform database row tests.
Specifies the library name that contains the QAQQINI query options file.
Defines the name of the DB2 for i5/OS database on the local system that contains the source tables for CDC in a remote journaling environment.
Defines the name of the i5/OS host system that contains the DB2 source tables for CDC, local journals, and journal receivers.


We’d like to hear from you!