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

Changing IMS Source Schema

Changing IMS Source Schema

If you need to change the structure an IMS database that is registered for change capture, use this procedure to retain access to historically captured data while capturing data of the new format.
  1. Stop all update activity against the IMS database.
  2. Verify that the IMS log-based ECCR has captured all changes under the current schema.
  3. Stop the IMS log-based ECCR.
  4. Complete extraction processing of all captured changes for the IMS database.
  5. Make the schema changes.
  6. Create a new capture registration that reflects the schema changes.
  7. Restart the IMS log-based ECCR.
  8. Allow update activity to the IMS database to resume.

0 COMMENTS

We’d like to hear from you!