Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange Utilities
  3. createdatamaps - Data Map Creation Utility
  4. DTLCCADW - Adabas PCAT Utility
  5. DTLCUIML - IMS Log Marker Utility
  6. DTLINFO - Release Information Utility
  7. DTLREXE - Remote Execution Utility
  8. DTLUAPPL - Restart Token Utility
  9. DTLUCBRG - Batch Registration Utility
  10. DTLUCDEP - CDEP Maintenance Utility
  11. DTLUCSR2 - IDMS SR2 and SR3 Records Utility
  12. DTLUCUDB - DB2 for Linux, UNIX, and Windows CDC Utility
  13. DTLULCAT and DTLULOGC - IDMS Log Catalog Utilities
  14. DTLURDMO - Data Map Utility
  15. DTLUTSK - Task Control Utility
  16. EDMLUCTR - Log Scan and Print Utility
  17. EDMXLUTL - Event Marker Utility
  18. HOSTENT - TCP/IP Address Reporter Utility
  19. PWXCATMY - MySQL Catalog Utility
  20. PWXUCCLPRT - Print Log Summary Utility
  21. PWXUCDCT - Logger for Linux, UNIX, and Windows Utility
  22. PWXUCREG - Capture Registration Suspend Utility
  23. PWXUCRGP - Capture Registrations Print Utility
  24. PWXUDMX - Data Maps Update Time ECSA Memory Utility
  25. PWXUGSK - SSL Reporting Utility for z/OS
  26. PWXUMAP - Map List Utility
  27. PWXUSSL - PowerExchange SSL Reporting Utility

Suspending Change Capture for Registered Sources Temporarily

Suspending Change Capture for Registered Sources Temporarily

Use this task flow to suspend change capture processing for registered sources temporarily.
You perform some tasks with the PWXUCREG utility and other tasks outside of the utility on the z/OS system.
Before you begin, ensure that the REFRESH_ALLOWED=Y parameter is specified in the ECCR configuration file. Also, you must have the authority to issue a REFRESH command after each registration status change.
  1. Stop database activity for the registered source or sources for which you want to suspend capture registrations.
  2. To suspend the capture registrations, use the PWXUCREG utility to issue the SUSPEND_REGISTRATION command.
    The suspension window opens. The utility sets the suspension timestamp to the current system time without any adjustment for the local time. Also, the utility issues message PWX-03716 to the DTLLOG log to report the registration status change.
    For each suspended registration, the PowerExchange Navigator Resource Inspector displays
    Suspended
    in the
    Status
    field and the suspension timestamp in the
    Suspend Time
    field. The
    Suspend Time
    value is not adjusted for the local time.
  3. For Adabas sources only, perform a PLOG switch.
    This step ensures that all of the changes up to the point of the PLOG switch are captured for the active registration.
  4. Enter the ECCR REFRESH command with the MVS MODIFY (F) command:
    F
    eccr_task_name
    ,REFRESH
    The ECCR becomes aware of the registration status change and suspension timestamp. When the ECCR encounters the first change record to discard, it issues message PWX-07752. The ECCR discards change records that have a timestamp later than the suspension timestamp.
  5. Run the jobs or processes that generate the changes that you do not want to capture for the source or sources that are associated with the suspended registrations.
  6. To reactivate the capture registrations, use the PWXUCREG utility to issue the ACTIVATE_REGISTRATION command.
    The suspension window closes. The utility sets the activation timestamp to the current system time without any adjustment for the local time. Also, the utility issues message PWX-03716 to the DTLLOG log to report the registration status change.
    For each reactivated registration, the PowerExchange Navigator Resource Inspector displays
    Active
    in the
    Status
    field and the activation timestamp in the
    Active Time
    field. The
    Active Time
    value is not adjusted for the local time.
  7. For Adabas sources only, perform a PLOG switch.
    This step ensures that all of the changes that occur during the suspension window up to the PLOG switch are discarded for the suspended registration.
  8. Enter the ECCR REFRESH command with the MVS MODIFY (F) command again.
    The ECCR becomes aware of the registration status change and activation timestamp.
  9. Enable database activity to resume on the registered source or sources.
    The ECCR starts capturing change records that have timestamps later than the activation timestamp. The ECCR issues message PWX-07753 when it encounters the first change record in the change stream after the end of the suspension window.
You can automate this processing if appropriate for your environment.

0 COMMENTS

We’d like to hear from you!