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

PowerExchange Condense Overview

PowerExchange Condense Overview

PowerExchange Condense captures change data from DB2 for
i5/OS
databases and writes that data to condense files. You can make the change data in the condense files available for extraction processing at user-defined intervals.
When you create a capture registration for a data source, you must set the
Condense
option to
Full
or
Part
to indicate the type of condense processing.
If you select
Full
, PowerExchange Condense uses full condense processing. Full condense processing does not maintain transactional integrity, but it can decrease the amount of change records that are processed and extracted. During a full condense cycle, PowerExchange Condense records only the last change made to a row in a condense file. If multiple changes are made to the same row, later changes supersede earlier changes, leaving only the latest change. Use the following criteria to determine if you want to use full condense processing:
  • For full condense processing, tables must have a primary index or a unique key that is defined through DDS. PowerExchange Condense creates keys in the condense files based on the key columns in the source tables to uniquely identify rows.
  • If a source file includes multiple data members, do not use full condense processing unless the primary key for the file is unique across all data members. Otherwise, unpredictable results might occur.
  • If changes for different tables are written to the same full condense file, the record size is determined by the largest change record.
  • If a change is recorded for a row in a full condense file and then a condense file switch occurs while additional changes for that row are pending, you might get a change record for the row in both condense files. This situation depends on the file switch parameters and the level of change activity in your environment.
If you select the
Part
option, PowerExchange Condense uses partial condense processing. Partial condense processing maintains transactional integrity because PowerExchange Condense does not eliminate any change. During a partial condense cycle, PowerExchange Condense writes all of the changes for successfully completed UOWs to condense files, in chronological order by UOW end time. If a DB2 for i5/OS table is updated outside of commit control, PowerExchange Condense writes changes in the order that each update occurred. To save disk space, PowerExchange Condense organizes records in partial condense files into 32 KB blocks. The records might appear incorrect if you access them through the
i5/OS
DSPPFM command.
Instead of using PowerExchange Condense partial condense processing, you can use the PowerExchange Logger for Linux, UNIX, or Windows to offload condense processing from the i5/OS system. For more information about remote logging, see the
PowerExchange CDC Guide for Linux, UNIX, and Windows
.

0 COMMENTS

We’d like to hear from you!