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 Log Files

PowerExchange Logger Log Files

The PowerExchange Logger creates log files for storing change data records when it first encounters changes for source tables and columns of interest. These source tables and columns must be defined in active capture registrations.
The PowerExchange Logger creates log files based on the EXT_CAPT_MASK parameter in the pwxccl configuration file. This parameter specifies a path to the directory where the log files are stored and a prefix for the log file names. Log file names have the following format:
path
/
prefix
.CND.CP
yymmdd
.T
hhmmnnn
Where:
  • path/prefix
    is the EXT_CAPT_MASK value.
  • yymmdd
    is the date when the file is created.
  • hhmm
    is a 24-hour time when the file is created.
  • nnn
    is a generated sequence number that makes each file name unique.
The log files remain open until a file switch occurs or the PowerExchange Logger shuts down.
When you run a PowerCenter CDC session in continuous extraction mode or batch extraction mode, PowerExchange extracts change data from the PowerExchange Logger log files.

0 COMMENTS

We’d like to hear from you!