Hi, I'm Bolo!
What would you like to know?
ASK BOLOPreview
Please to access Bolo.
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.0
  • All Products

Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange Commands
  3. Adabas Log-Based ECCR Commands
  4. Batch VSAM ECCR Commands
  5. CICS/VSAM ECCR Commands
  6. Datacom Table-Based ECCR Commands
  7. DB2 for z/OS ECCR Commands
  8. IDMS Log-Based ECCR Commands
  9. IMS Synchronous ECCR Commands
  10. IMS Log-Based ECCR Commands
  11. PowerExchange Agent Commands
  12. PowerExchange Condense Commands
  13. PowerExchange Listener Commands
  14. PowerExchange Logger for MVS Commands
  15. PowerExchange Logger for Linux, UNIX, and Windows Commands
  16. pwxcmd Commands

Command Reference

Command Reference

Back Next

REFRESH Command

REFRESH Command

Refreshes the list of IDMS records with active capture registrations that the IDMS log-based ECCR uses to capture change data.
Issue this command in the following situations to update the list of registered sources without shutting down the ECCR:
  • After you add a capture registration.
  • After you delete a capture registration.
  • After you issue a PWXUCREG utility command that changes the registration status, such as the SUSPEND_REGISTRATION or ACTIVATE_REGISTRATION command. For more information, see the
    PowerExchange Utilities Guide
    .
To use this command, you must specify REFRESH_ALLOWED=Y in the RUNLIB(ECCRIDLP) member to which the DTLCACFG DD statement in the ECCR JCL points.
When you issue the command, the ECCR begins shutdown processing but does not end. The ECCR rebuilds the list of registered sources and initiates a special warm start. The ECCR reprocesses any UOWs that were open when the command was issued, beginning with the earliest open UOW. After the ECCR has reprocessed all of the open UOWs up to the current log read position, it resumes normal processing.

Syntax

Use the following command syntax: 
F 
eccr_task_name
,REFRESH
The
eccr_task_name
 variable is the name of the IDMS log-based ECCR job or started task.

Usage Notes

  • For a REFRESH operation, the ECCR reprocesses all of the open UOWs so that it can capture data for any registration that was added or avoid capturing data for any registration that was deleted.
  • For each registration that you add, you can control the point from which change capture begins for the new source. Before you issue the REFRESH command, stop change activity on the source, add the registration, and synchronize the source and target. Then issue REFRESH command and resume change activity on the source.
  • If you need to delete a registration, ensure that the ECCR has processed all changes for the registration before you delete it and issue the REFRESH command.
  • For each registration that you delete, ensure that all in-flight changes have been captured and that extraction processing has caught up to the current ECCR position of the IDMS logs before you issue the REFRESH command.
0 COMMENTS
We’d like to hear from you!