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

Generating PowerExchange Condense Performance Statistics

Generating PowerExchange Condense Performance Statistics

If you want to generate performance statistics for PowerExchange Condense, set VERBOSE=Y in the configuration file. The performance statistics are written to the PowerExchange log file.
The following types of statistics are reported:
  • Condense timing - total
    . Number of CPU seconds that PowerExchange Condense took to get data records from CAPI and write the records to the condense files. This timing indicates the amount of time that it took PowerExchange Condense to process the data records.
  • Condense timing - data
    . Number of CPU seconds that PowerExchange Condense took for all read and write processing.
  • CAPI read timing - data
    . Number of CPU seconds that CAPI took to read data records from the change stream.
  • CAPI read timing - total
    . Number of CPU seconds that CAPI took for all read operations.
  • Quantity of data processed
    . Total number of records, updates, UOWs, and bytes that PowerExchange Condense processed.
These timings do not include the time for PowerExchange Condense initialization and for repositioning after a restart.
The non-data timings indicate the amount of processing required to reach the restart point in the change stream after PowerExchange Condense issues the first read call.

0 COMMENTS

We’d like to hear from you!