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

If You Migrate to DB2 11 for z/OS

If You Migrate to DB2 11 for z/OS

DB2 11 introduces changes to the DB2 catalog tables that the DB2 ECCR uses and introduces support for the extended 10-byte format of RBA and LRSN values in DB2 log records.
Before you migrate to DB2 11 conversion mode (CM), check whether the DB2 ECCR capture directory tables support DB2 11. At initialization, the ECCR issues message PWXEDM177552I, which reports the highest DB2 version that the current ECCR capture directory tables support. If the capture directory tables have already been successfully upgraded to the level required for DB2 11, the message should report that the tables support DB2 11.
If you need to upgrade the ECCR capture directory tables, perform the upgrade before migrating any subsystem to DB2 11 CM. For more information, see Upgrading the DB2 ECCR Capture Directory Tables.
Also, check the DB2 DSN6SPRM RESTRICT_ALT_COL_FOR_DCC parameter setting. PowerExchange reports this setting in message PWXEDM177155I in the ECCR output. How this parameter is set determines whether you will need to cold start the ECCR during the migration to DB2 11 CM or enabling-new-function mode (enabling-NFM):
  • If the RESTRICT_ALT_COL_FOR_DCC parameter is set to NO, the ECCR will be able to process all DB2 log data that was generated during the DB2 catalog upgrade process and update the contents of the ECCR capture directory tables. If you migrate from DB2 11 CM to enabling-NFM, you must cold start the ECCR. However, if you migrate from enabling-NFM to new-function mode (NFM), you do
    not
     need to cold start the ECCR.
    If you use this setting, shut down the DB2 ECCR before you run the DB2 catalog upgrade utility, CATMAINT.
  • If the RESTRICT_ALT_COL_FOR_DCC parameter is set to YES, you must cold start the ECCR after migrating to DB2 11 CM and after migrating to DB2 11 NFM.
    In a data sharing environment, you might need to cold start the ECCR an additional time, depending on where the ECCR runs:
    • When the first member of the data sharing group is migrated to DB2 11, cold start the ECCR, regardless of whether the ECCR runs on this first-migrated member.
    • If the ECCR runs on another member of the data sharing group, when that member is migrated to DB2 11, cold start of the ECCR again.
      If you do not cold start the ECCR in these circumstances, the ECCR will not capture any DDL changes for the tables of CDC interest. In this case, the PowerExchange capture directory tables can become invalid, causing capture processing to fail for the tables with the DDL changes.
      A cold start of the ECCR is
      not
       required after you migrate any other member in the data sharing group.
    Before you migrate a subsystem on which the ECCR will be cold started, make sure that the DB2 ECCR has captured all of the available changes from the DB2 subsystem.
0 COMMENTS
We’d like to hear from you!