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

Synchronization of the Checkpoint File to the CDCT File

Synchronization of the Checkpoint File to the CDCT File

During a warm start of PowerExchange Condense, PowerExchange checks whether the records in the currrent checkpoint file that track the condense files match the records in the CDCT file with the same key fields. If the records in these files do not match, PowerExchange Condense synchronizes the CDCT file with the checkpoint file. Synchronization occurs during the PowerExchange Condense initialization phase only.
During synchronization, if a record is absent from the CDCT file and is present in the checkpoint file, the record from the checkpoint file is added to the CDCT file. However, if a record is absent from the CDCT file and the only corresponding record in the checkpoint file is a compressed RET record, PowerExchange cannot add the missing record to the CDCT file.
RET records are compressed records that contain only fields for the source instance, registration tag, condense file name, and retention information. They are used to delete CDCT records that reach the expiration threshold that is specified in the COND_CDCT_RET_P parameter in the CAPTPARM configuration member.
For each missing CDCT record that the synchronization process detects, PowerExchange issues warning message PWX-06446 and optionally issues the operator reply message PWX-06449. You must reply Y or N to the operator reply message to indicate whether to continue or end PowerExchange Condense processing. If PowerExchange Condense continues, some change data will not be extracted because the extraction processes will not be able to find all of the condense files based on the CDCT records. If you do not need to extract change data for the registrations and time stamps reported in the PWX-06446 messages for missing CDCT records, you can suppress the operator reply messages by setting the OPER_WTOR_ENABLED parameter to N in the CAPTPARM configuration member.
Under normal circumstances, the checkpoint file and CDCT file match. However, if the synchronization process detects that the records in these files differ, the records in the checkpoint file take precedence until a subsequent PowerExchange Condense warm start resynchronizes the files. In the following atypical situations, resynchronization might be necessary:
  • You want to use an older checkpoint file to restart PowerExchange Condense.
  • You restored the CDCT file from an older CDCT backup file and now want to bring the CDCT up to date.
  • You deleted all records for a particular instance from the CDCT file.

0 COMMENTS

We’d like to hear from you!