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 and Reporting
  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. Appendix A: DTL__CAPXTIMESTAMP Time Stamps
  15. Appendix B: PowerExchange Glossary

i5/OS DBMOVER Statements

i5/OS DBMOVER Statements

PowerExchange provides DBMOVER statements specific to the i5/OS operating system.
The following table briefly defines the DBMOVER statements specific to the IBM i operating system (previously called i5/OS or AS400) and provides cross-references to the complete description of the statements:
Statement
Description
Reference
AS400EVENTMSGQ
Specifies an event message queue on an i5/OS system to which PowerExchange writes messages that do not require an operator reply.
AS400USRJRNCODE
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.
AS400USRMSGQ
Specifies the message queue on an i5/OS system to which PowerExchange writes messages that require an operator reply.
CONSOLE_TRACE
Controls whether PowerExchange writes messages from TRACE statements to the MVS console for z/OS or to the QPRINT output for i5/OS, in addition to writing these messages to the PowerExchange message log file.
CPX_DIR
Specifies the name of the library that PowerExchange uses on i5/OS to read and store the extraction maps for DB2 for i5/OS CDC sources.
FILEMAPPED_MEMORY_DIR
Specifies the directory that stores temporary file-mapped memory files for PowerExchange Listener statistics on AIX PPC64, i5/OS (IBM i), and Solaris SP64 systems.
HOSTNAME
Specifies an i5/OS host name that overrides the host name that PowerExchange retrieves from the TCP/IP Host table for communications with the PowerExchange Listener on i5/OS.
IBMI_2ND_LEVEL_HELP
Controls whether IBM i second-level help information is included in PowerExchange messages that report operating system or API errors.
IBMI_SUPPRESS_OUTPUT
Suppresses spool file creation for PowerExchange tasks.
RMTRDBDIRE
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.