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

CAPI_CONN_NAME Statement

The CAPI_CONN_NAME statement specifies the name of the CAPI_CONNECTION statement that PowerExchange uses by default for all data source types when you do not supply a CAPI connection override.
All
CAPI_CONNECTION and CAPI_SRC_DFLT
No
CAPI_CONN_NAME=
capi_connection_name
For the
capi_connection_name
variable, enter the name of the CAPI_CONNECTION statement that PowerExchange uses when you do not specify a CAPI_CONNECTION override value.
  • Optionally, you can use the CAPI_SRC_DFLT statement to provide a source-specific default connection. A source-specific default is useful if the DBMOVER configuration file contains many CAPI_CONNECTION statements.
  • Informatica recommends that you always specify an override CAPI_CONNECTION statement for a PowerExchange operation, instead of relying on default connection definitions. You can define the following overrides, based on the type of PowerExchange operation:
    • For CDC sessions, specify the
      CAPI Connection Name Override
      attribute on the PWX CDC application connection.
    • For PowerExchange Condense, specify the CONN_OVR statement in CAPTPARM configuration file.
    • For the PowerExchange Logger for Linux, UNIX, and Windows, specify the CONN_OVR statement in pwxccl.cfg configuration file.
    • For the generation of restart tokens with the DTLUAPPL utility, specify the CONN_OVR statement in the DTLUAPPL control statement.
    • For CAPXRT database row tests in the PowerExchange Navigator, specify the
      CAPI Connection Name
      value in the
      Advance
      dialog box.
    • For the generation of restart tokens during a database row test in the PowerExchange Navigator, specify the CONNAME parameter.
    • For PowerExchange ODBC connections, specify the DTLCONN_OVR parameter in the odbc.ini file or the DTLCONNOVR SQL escape sequence override.

0 COMMENTS

We’d like to hear from you!