Command Reference

10.5.4
- 10.5.5
- 10.5.3
- 10.0

Back Next

pwxcmd displaystats Command

Displays PowerExchange Logger for Linux, UNIX, and Windows monitoring statistics. The command can report statistics for the PowerExchange Logger process and tasks or PowerExchange Logger group definitions, depending on the -type (-tp) argument that you use.

Before you run the command, you must configure the STATS=(MONITOR) parameter in the PowerExchange Logger pwxccl.cfg configuration file on the system where the PowerExchange Logger runs to enable collection of the monitoring statistics.

If you use the default value of

-tp logger

in the command, the command reports the following statistics:

The PowerExchange Logger process ID

The status of the PowerExchange Logger Writer subtask

The CPU time used by the PowerExchange Logger since it started

PowerExchange Logger memory use, total and for 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 and for 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 processed, total and for the open Logger log file and the active logging cycle

If you specify

-tp groups

in the command, the command reports the following statistics for each PowerExchange Logger group that is defined:

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

Use the following syntax:

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

The following table describes pwxcmd displaystats options and arguments:

Option	Argument	Description
-service -sv	`service_name`	Required. Service name for the PowerExchange Logger for Linux, UNIX, and Windows process.
-user -uid -u	`user_ID`	Required if you enable security. A valid operating system user ID on the system that is the target of the command. For a PowerExchange Logger on a supported Linux, UNIX, or Windows system, if you have enabled PowerExchange LDAP user authentication, the user name is the enterprise user name. For more information, see the PowerExchange Reference Manual .
-password -pwd -p	`password`	Plain text password. If you specify a user ID, you must specify a plain text password or an encrypted password.
-epassword -e	`encrypted_password`	Encrypted password. If you specify a user ID, you must specify a plain text password or an encrypted password. .
-type -t	`report_type`	Optional. Indicates the type of PowerExchange Logger report. Options are: logger . Reports 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 . Reports statistics for each PowerExchange Logger group definition. A group definition defines a set of PowerExchange Logger log files for a group of registered source tables. 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, the timestamp of the open log file, and the number of change records that have not yet been flushed to a log file. If no group definitions are defined, reports these and some other statistics as if all source tables and registrations were in one large group. Default is logger.