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

Controlling and Stopping PowerExchange Logger Processing

Controlling and Stopping PowerExchange Logger Processing

PowerExchange provides commands for stopping the PowerExchange Logger, manually initiating a file switch, or starting another logging cycle.
You can enter these commands from the command line or by using the pwxcmd program on a remote Linux, UNIX, or Windows system. The output is displayed on screen and written to the PowerExchange message log.
To use the pwxcmd program, you must specify the CONDENSENAME parameter in the pwxccl.cfg file and the SVCNODE statement in the dbmover.cfg file.
The following table describes each of these commands:
Command-line Command
pwxcmd Command
Description
CONDENSE
condense
When the PowerExchange Logger is running in continuous mode, manually starts a new PowerExchange Logger logging cycle before the wait period for starting another cycle has elapsed. The wait period is defined by the NO_DATA_WAIT parameter in pwxccl.cfg.
FILESWITCH
fileswitch
Closes open PowerExchange Logger log files if they contain data and then switches to a new set of log files. If the log files do not contain data, the file switch does not occur.
If you use batch extraction mode, you can use this command to make change data in the current log files available for extraction processing before the next file switch is due to occur. To issue the fileswitch command from a script or batch file, you must use the pwxcmd program. Usually, you do not need to perform manual file switches if you use continuous extraction mode.
SHUTCOND
shutcond
Stops the PowerExchange Logger in a controlled manner after initiating and completing a final logging cycle. The final logging cycle enables the PowerExchange Logger to capture all of the changes up to point when the command is issued. After the logging cycle completes, the PowerExchange Logger closes open log files, updates the CDCT file, closes the CAPI, stops the Writer and Command Handler subtasks, and then ends the pwxccl program. Use this command if a logging cycle has not run recently.
SHUTDOWN
shutdown
Stops the PowerExchange Logger in a controlled manner after closing any open PowerExchange Logger log files and writing the latest restart position to the CDCT file. During shutdown processing, the PowerExchange Logger closes open log files, updates the CDCT file, closes the CAPI, stops the Writer and Command Handler subtasks, and then ends the pwxccl program. Use this command to stop a PowerExchange Logger process that is running in continuous mode.
For more information about command syntax, example output, and pwxcmd use, see the
PowerExchange Command Reference
.

0 COMMENTS

We’d like to hear from you!