Table of Contents

Search

  1. Preface
  2. Change Data Capture Introduction
  3. PowerExchange Listener
  4. PowerExchange Condense
  5. DB2 for i5/OS Change Data Capture
  6. Remote Logging of Data
  7. Introduction to Change Data Extraction
  8. Extracting Change Data
  9. Monitoring CDC Sessions
  10. Managing Change Data Extractions
  11. Tuning CDC Sessions
  12. Appendix A: DTL__CAPXTIMESTAMP Time Stamps

CDC Guide for i5/OS

CDC Guide for i5/OS

Customizing the dbmover File on the System to Which Data Is Logged

Customizing the dbmover File on the System to Which Data Is Logged

For the PowerExchange Logger for Linux, UNIX, and Windows to log data from a remote DB2 for i5/OS source, you must customize the dbmover configuration file on the system where the PowerExchange Logger log files will reside.
PowerExchange provides a sample dbmover file in the PowerExchange installation directory. You can copy this file and customize the copy. For a complete list of all dbmover configuration statements, see the
PowerExchange Reference Manual
.
The following table describes the dbmover statements that are used for remote logging:
Statement
Description
CAPT_PATH
Required. The path to the directory on the Linux, UNIX, or Windows system where the PowerExchange Logger CDCT file resides. The PowerExchange Logger stores information about its log files in the CDCT file.
Each PowerExchange Logger that captures change data requires its own CDCT file.
CAPX CAPI_CONNECTION
Required. Parameters that the Consumer API (CAPI) uses for continuous extraction of change data from PowerExchange Logger for Linux, UNIX, and Windows log files.
The DFLTINST parameter value in this statement must match the DBID value in the PowerExchange Logger configuration file, pwxccl.
LOGPATH
Optional. A unique path and directory for PowerExchange message log files on the Linux, UNIX, or Windows system where the PowerExchange Logger logs data in its log files.
NODE
Required. Information that PowerExchange uses to connect to the PowerExchange Listener on the source system from which change data is captured. This information includes a unique user-defined node name, the TCP/IP host name, and the port number.
The node name that you enter in this statement must match the CAPTURE_NODE parameter value in the PowerExchange Logger configuration file.
Source-specific CAPI_CONNECTION
Required. A named set of parameters that the CAPI uses to connect to the change stream for a source type and control CDC processing.
Copy the source-specific CAPI_CONNECTION statements from the DBMOVER configuration file on the source system. For DB2 for i5/OS sources, copy the AS4J and UOWC CAPI_CONNECTION statements.
SVCNODE
Optional. The
TCP/IP
port on which a command-handling service for a PowerExchange process, such as a PowerExchange Logger for Linux, UNIX, and Windows process, listens for pwxcmd commands.
TRACING
Optional. Enables PowerExchange alternative logging and specifies attributes for the alternative log files. PowerExchange uses the alternative log files instead of the default PowerExchange message log file to store messages.

0 COMMENTS

We’d like to hear from you!