Before you run one of these commands, you must configure the STATS=(MONITOR) parameter in the PowerExchange Logger pwxccl.cfg configuration file to enable collection of the statistics. In this parameter, you can include the optional
interval
subparameter to also publish the statistics at a regular interval.
Issue the commands in the following ways:
Issue the DL and DG commands from the command line window on the Linux, UNIX, or Windows system where the PowerExchange Logger runs. The PowerExchange Logger must be running in the foreground.
Issue the pwxcmd displaystats -tp logger or pwxcmd displaystats -tp groups command from a Linux, UNIX, or Windows system to the PowerExchange Logger on a remote system or the same system. You must use this method to issue the command to a PowerExchange Logger process that runs in background mode.
The command output is displayed on screen and printed to the PowerExchange message log.
The DL and pwxcmd displaystats -tp logger commands produce statistics for the PowerExchange Logger process and its tasks. The following example report shows these statistics:
PWX-26011 Command handler received command "DS"
PWX-00723 Command <display L stats> succeeded
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
This report contains the following fields:
PWXCCL pid. The process ID of the PowerExchange Logger process.
Writer status. The status of the PowerExchange Logger Writer subtask at the time the command was issued.
CPU Time. The amount of CPU time used by the PowerExchange Logger since it started.
Controller. The amount of memory in kilobytes that the PowerExchange Logger Controller has used.
Command Handler. The amount of memory in kilobytes that the PowerExchange Logger Command Handler has used.
Writer. The amount of memory in kilobytes that the PowerExchange Logger Writer subtask has used.
Status. The process ID of the PowerExchange Logger process.
I, U, D, C, and Total. Counts of inserts, updates, deletes, and commits that the PowerExchange processed, with the total for all of these operation types. These values are reported for the PowerExchange Logger process, the currently open log file, and the active logging cycle.
CurrentFileOpened. The timestamp that indicates when the log file was opened.
Active Cycle. The timestamp that indicates when the active logging cycle started.
Logger Group Definition Reports
The DG and pwxcmd displaystats -tp groups commands produce statistics for each PowerExchange Logger group definition that is definition. A
group definition
defines a set of PowerExchange Logger log files for a group of registered source tables. The following example report shows these statistics:
PWX-26011 Command handler received command "DG"
PWX-37138 Grp: dtld004 Regs=1 IUD=000000000000 C=000000000000 Unflushed=000000000000
PWX-37138 Grp: dtld003 Regs=2 IUD=000000000470 C=000000000028 Unflushed=000000000000
PWX-37138 Grp: dtld002 Regs=2 IUD=000000003276 C=000000000196 Unflushed=000000000000
This report contains the following fields:
Grp. The name of the group definition.
Regs. The number of capture registrations in the group.
IUD. the total number of inserts, updates, and deletes processed for the group.
C. The number of commits processed for the group.
Unflushed. The number of change records for the group that have not yet been flushed to PowerExchange Logger log files on disk.
If no PowerExchange Logger groups are defined, the command reports the following monitoring statistics for the PowerExchange Logger, as if all of the registrations were in one group named "condenseO":
PWX-26011 Command handler received command "DG"
PWX-37138 Grp: c:\pwx\capture/condenseO Regs=5 IUD=000000032292 C=000000001931 Unflushed=000000034223
PWX-37139 FirstRec=2015-05-22 13:59:10.603648 Open file=c:\pwx\capture/condenseO.CND.CP150707.T1816001
PWX-37140 BeginSeq =000000009DE6000000000000000088D800000000 BeginRstrt =D4C9C7D340400000000037DA00000000
PWX-37141 LastSeq =0000015874380000000000000158728600000000
PWX-37142 CommitSeq=000001589B2400000000000001589B2400000000 CommitRstrt=D4C9C7D340400000000037DA00000000
FirstRec. The timestamp of the first record in the open Logger log file.
BeginSeq. The sequence token of the earliest record in the open Logger log file.
BeginRstrt. The restart token of the earliest record in the open Logger log file.
LastSeq. The sequence token of the last change record in the Logger log file that is not followed by a commit record. This value should be greater than the CommitSeq value.
CommitSeq. The sequence token of the last commit record in the Logger log file.
CommitRstrt. The restart token of the last commit record in the Logger log file.
For more information about the command syntax, see the
PowerExchange Command Reference
.
