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

Configuring PowerCenter Connection Attributes for Extracting Data from the Log Files

Configuring PowerCenter Connection Attributes for Extracting Data from the Log Files

For CDC sessions to extract change data from PowerExchange Logger for Linux, UNIX, and Windows log files on a system other than the source system, you must configure certain attributes on the PWX CDC Real Time connection.
The following table describes these connection attributes:
Connection Attribute
Value
Location
Enter the node name for the PowerExchange Listener that runs on the system where the PowerExchange Logger log files reside.
If the log files are on the PowerCenter Integration Service machine, you can enter "local."
Map Location
Enter the node name for the location where the PowerExchange Listener on the source system stores the extraction maps. Usually, this node is the source system node.
Map Location User and Map Location Password
Enter a user ID and password that can access the extraction maps.
If the PowerExchange Listener runs on a source system with PowerExchange security enabled, the user ID and password depends on the SECURITY statement settings in the DBMOVER configuration file.
If the first parameter in the SECURITY statement is 2 and you are extracting z/OS data from the log files, enter a valid z/OS user ID and password in these fields. Also ensure that these z/OS user credentials have the following permissions:
  • READ access to the PowerExchange data set that is defined in the DTLCAMAP DD statement of the PowerExchange Listener JCL
  • READ access to CAPX.CND.* resource profiles in the FACILITY class, which are managed by your z/OS security product
CAPI Connection Name Override
Enter the name of the CAPX CAPI_CONNECTION statement that is used by the PowerExchange Listener on the system where the PowerExchange Logger for Linux, UNIX, and Windows log files reside.
For more information about PWX CDC Real Time application connections, see
PowerExchange Interfaces for PowerCenter
.

0 COMMENTS

We’d like to hear from you!