Table of Contents

Search

  1. Preface
  2. Part 1: PowerExchange CDC Introduction
  3. Part 2: PowerExchange CDC Components
  4. Part 3: PowerExchange CDC Data Sources
  5. Part 4: Change Data Extraction
  6. Part 5: Monitoring and Tuning
  7. Appendix A: DTL__CAPXTIMESTAMP Time Stamps

CDC Guide for Linux, UNIX, and Windows

CDC Guide for Linux, UNIX, and Windows

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!