DG

Displays monitoring statistics for each PowerExchange Logger for Linux, UNIX, and Windows group that is defined. A group is a set of PowerExchange Logger log files for a group of registered source tables. The following statistics are reported:

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

DL

Displays monitoring statistics for a PowerExchange Logger for Linux, UNIX, and Windows process and its tasks. The following statistics are reported:

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, total and by the Controller, Command Handler, and Writer tasks. For the tasks, memory use is reported in the following categories:
Current. The amount of memory that the task is currently using.
Total. The amount of memory in use by the task plus related header overhead. This value fluctuates as memory is dynamically allocated and freed during PowerExchange Logger processing
Maximum. The largest amount of memory that has been recorded for the "Total" category up to the point in time when the monitoring statistics are generated.
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

pwxcmd displaystats {-service|-sv} 
service_name 
                [{-user|-uid|-u} user_ID 
                [{-password |-pwd|-p} 
password}|{-epassword|-e} 
encrypted_password}] 
               
 [{-type|-tp} [{
logger|groups}]

logger
. Report monitoring statistics for the PowerExchange Logger process and tasks. The statistics include the PowerExchange Logger process ID (PID), Writer subtask status, CPU time used, memory use by task type, and counts of inserts, updates, deletes, and commits processed.
groups
. Report statistics for each PowerExchange Logger group that is defined. The statistics include the number of registrations in the group, the total number of DML operations processed, the number of commits processed, the name of the open Logger log file for the group, the timestamp of the open log file, and the number of change records that have not yet been flushed to a log file.