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

Condense Group Definition Example

Condense Group Definition Example

Use this example to learn how you might use a group definition file.
The following table lists the registrations and tables that this example uses:
Registration
Table Name
regemp1
COMPANY.EMPLOYEES
regemp2
COMPANY.EXEMPLOYEES
regmgr
COMPANY.MANAGERS
regloc1
COMPANY.UK_LOCATIONS
regloc2
COMPANY.US_LOCATIONS
regloc3
COMPANY.JAPAN_LOCATIONS
regdept1
COMPANY.DEPTS
Based on these registrations, the following example group definition file creates separate sets of condense files for the groups called Personnel, Locations, and Departments:
GROUP=(Personnel,DTLUSR.PERSCOND) REG=regemp* REG=regmgr GROUP=(Locations,DTLUSR.LOCCOND) REG=regloc* GROUP=(Departments,DTLUSR.DEPTCOND) REG=regdept1
In this definition file, the asterisk (*) is used a wildcard character. Consequently, the REG=regemp* specification includes both the regemp1 and regemp2 registrations. The REG=regloc* specification includes the regloc1, regloc2, and regloc3 registrations.

0 COMMENTS

We’d like to hear from you!