You can stop CDC sessions from PowerCenter or PowerExchange.
In PowerCenter, issue the Stop or Abort command in Workflow Monitor. Alternatively, use the pmcmd stoptask, stopworkflow, aborttask, or abortworkflow commands.
If you issue the Stop command in Workflow Monitor or use the pmcmd stoptask or stopworkflow command, the PWXPC CDC reader and PowerCenter Integration Service complete processing all of the data in the pipeline and shut down. Then, the CDC session ends.
If you issue the Abort command in Workflow Monitor or use the pmcmd aborttask or abortworkflow command, the PowerCenter Integration Service waits 60 seconds to allow the readers and writers to complete processing all of the data in the pipeline and shut down. If the PowerCenter Integration Service cannot finish processing and committing data within this period, it kills the DTM process and ends the CDC session.
For more information about these PowerCenter commands, see the
Informatica Command Reference
or
PowerCenter Workflow Basics Guide
.
In PowerExchange, issue the PowerExchange Listener STOPTASK command in one of the following ways:
From the command line on the system where extraction processing occurs
From the PowerExchange Navigator
With the DTLUTSK utility
With the pwxcmd program
When you issue the STOPTASK command, PowerExchange stops the extraction task in the PowerExchange Listener and passes an EOF to the PowerCenter Integration Service. Then the CDC session ends. For more information about the STOPTASK command, see the