Table of Contents

Search

  1. Preface
  2. Part 1: PowerExchange CDC Introduction
  3. Part 2: PowerExchange CDC Components
  4. Part 3: PowerExchange CDC Data Sources
  5. Part 4: Change Data Extraction
  6. Part 5: Monitoring and Tuning
  7. Appendix A: DTL__CAPXTIMESTAMP Time Stamps

CDC Guide for Linux, UNIX, and Windows

CDC Guide for Linux, UNIX, and Windows

PowerExchange Logger Usage Considerations

PowerExchange Logger Usage Considerations

Before you run the PowerExchange Logger for Linux, UNIX, or Windows, review the following usage considerations:
  • Informatica recommends that you run the PowerExchange Logger for Linux, UNIX, and Windows and the process that extracts data from the PowerExchange Logger log files on the same system. Configure a PowerExchange Listener on the PowerExchange Logger system and specify that node location in the
    Location
    attribute of the PowerCenter PWX CDC connection. If you run the PowerExchange Logger and extraction process on different systems and use NFS to access the log files, disable attribute and data caching for the NFS mount point. Otherwise, session failures might occur.
  • On Linux and UNIX, the PowerExchange Logger requires sufficient amounts of main memory and virtual memory to process change data. If the memory is not sufficient, PowerExchange writes the error messages PWX-00271 and PWX-00904 to the PowerExchange message log file when you attempt to start the PowerExchange Logger on Linux or UNIX.
    To prevent this problem, use the Linux or UNIX ulimit command to set the size limits for maximum memory and virtual memory to unlimited. The specific ulimit syntax varies by platform and shell. For more information about this command, see the documentation for your Linux or UNIX operating system.
  • On Linux and UNIX, you can run a PowerExchange Logger process in background mode. For background PowerExchange Logger processes, Informatica recommends that you set the COLL_END_LOG parameter to 0 in the pwxccl configuration file to run the PowerExchange Logger continuously. Also, set the PROMPT parameter to N. If you use PROMPT=Y, the PowerExchange Logger ignores this setting and issues an error message. To send commands to a PowerExchange Logger process that is running in the background, use the pwxcmd program. To enable pwxcmd use, define the CONDENSENAME statement in the pwxccl configuration file and define the SVCNODE statement in the dbmover configuration file.

0 COMMENTS

We’d like to hear from you!