CDC Guide for Linux, UNIX, and Windows

10.5
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Monitoring the PowerExchange Logger

PowerExchange provides several commands that you can use for monitoring PowerExchange Logger processing and performance.

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 summarizes these commands:

Command-line Command	pwxcmd Command	Description
DG	pwxcmd displaystats -tp groups	Displays monitoring statistics for each PowerExchange Logger group that is defined, if any. The statistics include: The group name and the number of capture registrations in the group The total number of insert, update, and delete records that the PowerExchange Logger processed for the group The number of commits that the PowerExchange Logger processed for the group The number of change records that the PowerExchange Logger has not yet flushed from memory to its log files on disk The file name of the open Logger log file and the timestamp for when the file was opened To use this command, you must specify the STATS=(MONITOR) parameter in the pwxccl.cfg configuration file.
DISPLAY CPU	pwxcmd displaycpu	Displays the CPU time spent, in microseconds, for PowerExchange Logger processing during the current logging cycle, by processing phase. Processing phases include: Reading source data Writing data to PowerExchange Logger log files Performing file switches Performing "other processing," such as initialization and Command Handler processing of commands Also includes the total CPU time for all PowerExchange Logger processing.
DISPLAY EVENTS	pwxcmd displayevents	Displays events that the PowerExchange Logger Controller, Command Handler, and Writer tasks are waiting on. Also indicates if the Writer is processing data or is in a sleep state while waiting for an event or timeout to occur.
DISPLAY MEMORY	pwxcmd displaymemory	Displays PowerExchange Logger memory use, in bytes, for each PowerExchange Logger task and subtask, with totals for the entire PowerExchange Logger process.
DISPLAY RECORDS	pwxcmd displayrecords	Displays counts of inserts, updates, deletes, and commits that the PowerExchange Logger processed during the current processing cycle. If the PowerExchange Logger did not receive changes during the current cycle, displays counts of change records for the current set of PowerExchange Logger log files.
DISPLAY STATUS	pwxcmd displaystatus	Displays the status of the PowerExchange Logger Writer subtask.
DL	pwxcmd displaystats -tp logger	Displays monitoring statistics for a PowerExchange Logger for Linux, UNIX, and Windows process and its tasks. The statistics include: The PowerExchange Logger process ID The status of the PowerExchange Logger Writer subtask at the time the command is issued The CPU time used by the PowerExchange Logger since it started PowerExchange Logger memory use by the Controller, Command Handler, and Writer tasks. For tasks, memory use is reported in the following categories: Current, Total, and Maximum. Counts of inserts, updates, deletes, and commits that the PowerExchange Logger has processed, total and for the open Logger log file and the active logging cycle To use this command, you must specify the STATS=(MONITOR) parameter in the pwxccl.cfg configuration file.

For more information about these commands and sample output, see the

PowerExchange Command Reference

If you specify the optional interval subparameter in the STATS=(MONITOR) parameter in the pwxccl.cfg configuration file, you can publish the same monitoring statistics that are reported by the DL command at a specific interval:

STATS=(MONITOR,interval)

Fewer interval-based statistics messages are displayed on screen than are written to the message log to prevent flooding the screen with messages over time. For example, the following messages are displayed on the screen:

PWX-37132    Controller: (981/983/1849) KB    Command Handler: (0/0/34) KB    Writer: (5127/5147/5181) KB
PWX-37135   Status  7144                  Totals  I=000000024344 U=000000000000 D=000000024336 C=000000004004 Total=000000052684
PWX-37136    CurrFileOpened : 2015-08-11 13:20:39 I=000000024344 U=000000000000 D=000000024336 C=000000004004 Total=000000052684
PWX-37137     Active Cycle  : 2015-08-11 13:21:01 I=000000024344 U=000000000000 D=000000024336 C=000000004004 Total=000000052684

The following interval-based statistics are written to the PowerExchange message log:

PWX-37130   PWXCCL pid = 7144       Writer status = Reading or waiting for source data
PWX-37134   CPU Time =    0:00:02.589616
PWX-37131   Memory  (Current/Total/Maximum)
PWX-37132    Controller: (981/983/1849) KB    Command Handler: (0/0/34) KB    Writer: (5127/5147/5181) KB
PWX-37135   Status  7144                  Totals  I=000000024344 U=000000000000 D=000000024336 C=000000004004 Total=000000052684
PWX-37136    CurrFileOpened : 2015-08-11 13:20:39 I=000000024344 U=000000000000 D=000000024336 C=000000004004 Total=000000052684
PWX-37137     Active Cycle  : 2015-08-11 13:21:01 I=000000024344 U=000000000000 D=000000024336 C=000000004004 Total=000000052684

Also, the PowerExchange Logger publishes summary monitoring statistics when it shuts down, provided that you specified STATS=(MONITOR) in the pwxccl.cfg file, either with or without the interval subparameter. A Logger that runs in continuous mode shuts down when you issue a SHUTCOND or SHUTDOWN command. A Logger that runs in batch mode shuts down when it reaches the end of its batch run. These summary monitoring statistics are included the shutdown output. For example output, see the Logger SHUTCOND and SHUTDOWN commands in the

PowerExchange Command Reference

Managing the PowerExchange Logger

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal