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 H2L
  • All Products

Table of Contents

Search

  1. Abstract
  2. Supported Versions
  3. PowerExchange CDC: Changing Sources or Targets for Extractions

PowerExchange CDC: Changing Sources or Targets for Extractions

PowerExchange CDC: Changing Sources or Targets for Extractions

Back Next

Changing Sources or Targets for a CDC Session

Changing Sources or Targets for a CDC Session

Use the following procedure to change sources or targets for an existing CDC session and then restart change data extraction from the appropriate point.
  1. Stop the PowerCenter workflow that contains the session that you want to change. Use one of the following methods:
    • Stop the workflow from the Workflow Monitor.
    • Issue the pmcmd
      stopworkflow
       command.
    • Issue the PowerExchange Listener STOPTASK command.
    • Use the PowerExchange DTLUTSK utility.
  2. After the workflow stops, right-click the CDC session and choose Recover Task or issue the pmcmd
    starttask
     command with the -recovery option.
    When you recover tasks for a session, PWXPC writes the ending restart tokens for all sources in the session to the restart token file that is specified in the CDC application connection. These restart tokens will be used to resume CDC processing from the appropriate point when the CDC session is restarted.
  3. In the Designer, edit or re-create the mapping to add or remove sources or targets.
  4. In the Workflow Manager, change the session.
    If you created a new mapping, you must create a new session. After validating the new session, update the workflow.
  5. Verify that the CDC application connection points to the same restart token file that was updated in the recovery session.
  6. If you added sources, update the restart token file to add restart tokens for those sources.
  7. If you removed sources, update the restart token file to remove the restart tokens for those sources.
  8. Cold start the CDC session
    PWXPC reads the restart token file to acquire restart tokens for all sources. PWXPC then passes these restart tokens to PowerExchange so that PowerExchange can resume change data extraction from the appropriate point in the change stream.
0 COMMENTS
We’d like to hear from you!