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

Suspending Change Capture for Registered Datacom Sources Temporarily

Suspending Change Capture for Registered Datacom Sources Temporarily

Use this task flow to suspend change capture processing for registered Datacom table-based CDC 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 RUNLIB(ECCRDCMP) member to which the DTLCACFG DD statement in the ECCR JCL points. 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. 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.
  4. 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.
  5. After the jobs or processes complete, use the PWXUCREG utility to issue the ACTIVATE_REGISTRATION command to reactivate the capture registrations.
    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.
  6. Enter the ECCR REFRESH command with the MVS MODIFY (F) command again.
    The ECCR becomes aware of the registration status change and activation timestamp.
  7. 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!