Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • PowerExchange for CDC and Mainframe 10.5.2
  • All Products

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

CDC Guide for z/OS

CDC Guide for z/OS

Back Next

DB2 CDC Operational Considerations

DB2 CDC Operational Considerations

Review the following operational considerations for DB2 for z/OS CDC:
  • The DB2 ECCR captures only the changes that are recorded in the DB2 log as SQL inserts, deletes, or updates.
  • The DB2 ECCR does not support change data capture for DB2 views and aliases.
  • The DB2 ECCR does not support change data capture for the TRUNCATE SQL statement with the IMMEDIATE option.
  • The DB2 ECCR does not capture changes that result from a DROP TABLE DDL statement or from a DB2 REORG utility operation that uses the DISCARD option.
  • The DB2 ECCR captures changes from the DB2 LOAD utility only if you specify the RESUME YES and SHRLEVEL CHANGE options for the utility. The DB2 ECCR does not capture changes from other DB2 utilities, even if you specify the LOG=YES option.
  • The DB2 ECCR does not capture changes from a single UOW that contains both DML and DDL changes for the same table, such as CREATE or ALTER TABLE statements and SQL inserts, deletes, and updates.
  • If a DDL operation changes the fixed length of a column, for example, CHAR(6) to CHAR(10), the DB2 ECCR cannot process DELETEs or old images of UPDATEs. To avoid potential problems, perform one of the following actions:
    • If you use DB2 version 11, perform a table REORG immediately after the DDL ALTER operation and before any DML changes occur on the table. The REORG reformats all rows. Otherwise, you will need to specify the SKIPURDML statement in the REPL2OPT DD data set to skip the unit of recovery (UR) that contains these changes, each time the ECCR fails to process a DML change.
0 COMMENTS
We’d like to hear from you!