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 Operational Modes

PowerExchange Condense Operational Modes

A PowerExchange Condense task can run in batch or continuous mode. To set the operational mode, use the COLL_END_LOG parameter in the PowerExchange Condense configuration member.
To determine which mode to use, review the following information:
batch mode
A single condense cycle runs and then the condense job shuts down. For example, you might want to use this mode if you insert a single condense process after update jobs in an automated schedule.
continuous mode
The condense job runs for a long period. PowerExchange Condense “sleeps” after each condense cycle. The next condense cycle is triggered by one of the following events:
  • The wait period defined by the NO_DATA_WAIT parameter elapses.
  • A CONDENSE command is manually entered on the i5/OS system, or a pwxcmd condense command is issued from a Linux, UNIX, or Windows system to the PowerExchange Condense process on the i5/OS system.
  • A FILESWITCH command is manually entered on the i5/OS system, or a pwxcmd fileswitch command is issued from a Linux, UNIX, or Windows system to the PowerExchange Condense process on the i5/OS system.
During continuous processing, condense files can be read by a change extraction process only after a file switch occurs. File switch processing closes the open condense files that contain data and opens a new set of condense files to accept change data. Extractions can process only the closed condense files. A file switch occurs when one of the following events occurs:
  • The file switch criteria defined by the FILE_SWITCH_CRIT and FILE_SWITCH_VAL parameters are met.
  • A FILESWITCH command or pwxcmd fileswitch command is issued.
The file switch does not occur if the current condense file contains no data. The next file switch attempt occurs when the criteria defined by the FILE_SWITCH_CRIT and FILE_SWITCH_VAL parameters are met. If the current condense file still contains no data, this cycle continues at the set intervals until the file contains data.
In continuous mode, the PowerExchange Condense process does not shut down. To shut down PowerExchange Condense, issue the PowerExchange Condense SHUTDOWN command from the command line on the i5/OS system. Alternatively, issue the pwxcmd shutdown command from a Linux, UNIX, or Windows system to the PowerExchange Condense process running on the i5/OS system.

0 COMMENTS

We’d like to hear from you!