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

PowerExchange ECCRs - Service Class Criteria

PowerExchange ECCRs - Service Class Criteria

PowerExchange ECCRs capture changes that are made to sources registered for change data capture.
The IMS synchronous ECCR, CICS/VSAM ECCR, and Batch VSAM ECCR capture changes as they occur. Because they run within the IMS region, CICS region, or address space of the batch job that makes the changes, they use the WLM service class of the region or batch job. Other types of ECCRs run as separate started tasks or jobs that read changes from database log files. You can assign these log-based ECCRs to an appropriate WLM service class.
When determining the WLM service class to use for the PowerExchange log-based ECCRs, consider their resource usage characteristics and performance requirements.
The PowerExchange log-based ECCRs have the following resource usage characteristics:
  • CPU usage is moderate. It depends on the volume of source database changes and the volume of change data that the ECCR is capturing.
  • I/O activity is moderate. It depends on the volume of source database changes and the volume of change data that the ECCR is capturing.
  • Virtual memory usage depends on the number of capture registrations.
The performance requirements for the PowerExchange log-based ECCRs depend on the type of ECCR and type of extraction, as follows:
  • The DB2 for z/OS and Datacom table-based ECCRs can capture change data from the online database log files. For these ECCRs, the service class depends on your change data extraction requirements, as follows:
    • If you run PowerCenter Real Time CDC sessions that use continuous extraction mode and need to deliver captured change data to the target with minimum latency, assign the PowerExchange ECCR and the database processes that log the changes to the same service class. With this service class configuration, the PowerExchange ECCR can keep up with these database processes.
    • If you run PowerCenter CDC sessions that periodically extract change data in batch mode from either PowerExchange Logger log files or from condense files, assign the PowerExchange ECCR to a service class that is used by batch jobs.
  • The Adabas, IMS log-based, and IDMS log-based ECCRs extract changes from archived database log files in asynchronous mode. PowerCenter CDC sessions that extract these changes run periodically. Assign these ECCRs to a service class that is used by batch jobs.

0 COMMENTS

We’d like to hear from you!