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

Stopping PowerCenter CDC Sessions

Stopping PowerCenter CDC Sessions

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
PowerExchange Command Reference
.

0 COMMENTS

We’d like to hear from you!