Command Reference

10.5.3
- 10.5.5
- 10.5.4
- 10.0

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

If no group definitions are defined, this command displays monitoring statistics for all of the registrations, as if they are in one group.

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

If PowerExchange Logger groups are defined, the command reports the following monitoring statistics for each group definition:

PWX-26011 Command handler received command "DG"
PWX-37138   Grp: /pwxprod/v1010/capture/dtld004 Regs=100 IUD=000001046400 C=000000000969 Unflushed=000000000000
PWX-37139       FirstRec=2016-05-11 21:26:49.000000  Open file=/pwxprod/v1010/capture/dtld004.CND.CP160525.T1917001
PWX-37140       BeginSeq =D4000019EA1124000000000000000019EA111A0000000000007591000004E9001000020000 
BeginRstrt =000019EA111A631850012F800103
PWX-37141       LastSeq  =D400001A023FA800000000000000001A023FA600000000000075F200014B27010400010000
PWX-37142       CommitSeq=D400001A025AAD000000000000FFFFFFFFFFFFFFFFFFFF000075F700011A440068FFFF0000 CommitRstrt=00001A025A5D631850012F800103
PWX-37138   Grp: /pwxprod/v1010/capture/dtld003 Regs=5 IUD=000000290000 C=000000000030 Unflushed=000000000000
PWX-37139       FirstRec=2016-05-25 19:19:58.000000  Open file=/pwxprod/v1010/capture/dtld003.CND.CP160525.T1920001
PWX-37140       BeginSeq =D400001A0243B800000000000000001A0243B200000001000075F3000018F7014000010000 BeginRstrt =00001A0243A1631850012F800103
PWX-37141       LastSeq  =D400001A025AAD00000000000000001A025AAA00000042000075F700011A3A015400010000
PWX-37142       CommitSeq=D400001A025AAD000000000000FFFFFFFFFFFFFFFFFFFF000075F700011A440068FFFF0000 CommitRstrt=00001A025A5D631850012F800103

If PowerExchange Logger groups are not defined, the command reports the following monitoring statistics for all of the registrations, as if they are 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=2016-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

These reports contain 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.

FirstRec. The timestamp of the first record in the open Logger log file.

Open file. The path and file name of 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 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