Table of Contents

Search

  1. Preface
  2. Part 1: PowerExchange Change Data Capture Introduction
  3. Part 2: CDC Components Configuration and Management
  4. Part 3: CDC Sources Configuration and Management
  5. Part 4: Change Data Extraction
  6. Part 5: Monitoring and Tuning
  7. Appendix A: CDC for z/OS Troubleshooting
  8. Appendix B: DTL__CAPXTIMESTAMP Time Stamps

KEY_CHANGE_ALW Parameter

KEY_CHANGE_ALW Parameter

Controls whether Condense jobs fail or continue when PowerExchange Condense detects a change to the source key columns during full condense processing.
This parameter applies only to full condense processing, which is enabled by selecting
Full
for the
Condense
option in the capture registration.
KEY_CHANGE_ALW={
N
|Y}
  • N
    . The Condense job fails when the change to the key columns is detected.
  • Y
    . The Condense job ignores the change to the key during full condense processing and continues.
Default is N.
  • If you have a DB2 for z/OS source, you can do an update operation to change any or all key columns in a row.
  • This parameter does not apply to partial condense processing.

0 COMMENTS

We’d like to hear from you!