Command Reference

10.0
- 10.5.5
- 10.5.4
- 10.5.3

Back Next

DG Command

Displays monitoring statistics for each PowerExchange Logger for Linux, UNIX, and Windows group definition that is defined. A group definition
defines a set of PowerExchange Logger log files for a group of registered source tables.

The command writes the following statistics to the PowerExchange message log file and displays the statistics on screen:

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

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.

Syntax

Use the following syntax to issue the command from the command line against a PowerExchange Logger process that is running in foreground mode:

DG

If you run the PowerExchange Logger in background mode, you must use the pwxcmd program to issue the displaystats -tp groups command.

Example Output

The following example command output shows the monitoring statistics for each PowerExchange Logger group definition:

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

This report contains the following additional fields:

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 report messages, see

PowerExchange Message Reference Volume 2

PowerExchange Logger for Linux, UNIX, and Windows Commands

pwxcmd displaystats Command

DL Command

Download Guide

Watch

Comments

Communities

Knowledge Base