Table of Contents

Search

  1. Preface
  2. Change Data Capture Introduction
  3. PowerExchange Listener
  4. PowerExchange Condense
  5. DB2 for i5/OS Change Data Capture
  6. Remote Logging of Data
  7. Introduction to Change Data Extraction
  8. Extracting Change Data
  9. Monitoring CDC Sessions
  10. Managing Change Data Extractions
  11. Tuning CDC Sessions
  12. Appendix A: DTL__CAPXTIMESTAMP Time Stamps

CDC Guide for i5/OS

CDC Guide for i5/OS

Stop Command Processing

Stop Command Processing

After you issue a stop command in PowerCenter or PowerExchange, the following processing occurs:
To stop CDC sessions and workflows, you can use the Stop command in Workflow Monitor or the pmcmd stopttask or stopworkflow command. Alternatively, you can use the PowerExchange STOPTASK command.
  1. If you use a PowerCenter stop command, the PowerCenter Integration Service requests PWXPC to stop.
    If you use the PowerExchange STOPTASK command, PowerExchange sends an EOF to PWXPC.
  2. When PWXPC receives an EOF, it flushes any complete and uncommitted UOWs and the associated restart tokens to the targets. PWXPC then writes messages PWXPC_12101 and PWXPC_12068 to the session log.
  3. The PowerCenter Integration Service processes all of data in the pipeline and writes it to the targets.
  4. The PowerCenter Integration Service sends an acknowledgment to PWXPC indicating that the targets have been updated.
  5. PWXPC writes the termination restart token file, and then writes the message PWXPC_12075 to the session log.
  6. The PWXPC CDC reader shuts down.
  7. The PowerCenter Integration Service performs any post-session tasks and ends the session.

0 COMMENTS

We’d like to hear from you!