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

Example pwxccl Configuration File

Example pwxccl Configuration File

PowerExchange provides an example PowerExchange Logger configuration file, pwxccl, in the PowerExchange installation directory. You can use this file to create a custom configuration file.
The following example shows basic configuration statements:
/* Name for PWXCMD control /*CONDENSENAME=PWXCCL1 DBID=ORACOLL1 DB_TYPE=ORA CAPTURE_NODE_UID=
user_id
CAPTURE_NODE_EPWD=
encrypted_password
/* CAPTURE_NODE_PWD=
plain_text_password
PROMPT=Y EXT_CAPT_MASK=/capture/condenseO COND_CDCT_RET_P=50 LOGGER_DELETES_EXPIRED_CDCT_RECORDS=Y /* 0 = continuous, 1 = Stop at end-of-log (batch) COLL_END_LOG=0 /* Number of minutes to wait between CAPI read cycles NO_DATA_WAIT=0 /* Number of seconds to wait at the end-of-log for more change data NO_DATA_WAIT2=60 /* Number of seconds before flushing, or writing, data to the current log file on disk /* -1 = No flush, 0 = flush every record, 1 to N flush every N seconds /*FILE_FLUSH_VAL=60 /* Minimum number of FILE_SWITCH_CRIT units after new CDCT source entry (normal,coldstart) FILE_SWITCH_CRIT=M FILE_SWITCH_VAL=20 CAPT_IMAGE=BA SEQUENCE_TOKEN=00 RESTART_TOKEN=00

0 COMMENTS

We’d like to hear from you!