Oninit Logo
The Down System Specialists
+1-913-674-0360
+44-2081-337529
Partnerships Contact
Onstat -a -b/-B -C -c -d/-D -F -f -G -h -i -j -k/-K -L -l -m -o -P -p -R -r -s -t/-T -u -X -x -z

onstat -g grp ER Grouper Statistics

The onstat -g grp command displays Grouper Statistics; the grouper evaluates the log records, rebuilds the individual log records into the original transaction, packages the transaction, and queues the transaction for transmission. The onstat -g grp command is used primarily as a debugging tool.

The command can take the following modifiers

ModifierAction
APrints all the information printed by the G, T, P, E, R, and S modifiers
EPrints grouper evaluator statistics
ExPrints grouper evaluator statistics, expands user-defined routine (UDR) environments
GPrints grouper general statistics
LPrints grouper global list
LxPrints grouper global list, expands open transactions
MPrints grouper compression statistics
MzClears grouper compression statistics
PPrints grouper table partition statistics
pagerPrints grouper paging statistics
RPrints grouper replicate statistics
SPrints grouper serial list head (The serial list head is the first transaction in the list, that is, the next transaction that will be placed in the send queue.)
SlPrints grouper serial list (The serial list is the list of transactions, in chronological order.)
SxPrints grouper serial list, expands open transactions
TPrints grouper transaction statistics
UDRPrints summary information about any UDR invocations by the grouper threads
UDRxPrints expanded information (including a summary of error information) about any UDR invocations by the grouper threads The Procid column lists the UDR procedure ID.
onstat -g grp

Grouper at 0x3d8371028:
Last Idle Time: (1370358802) 2013/06/04 10:13:22
RSAM interface ring buffer size: 3088
RSAM interface ring buffer pending entries: 0
Eval thread interface ring buffer size: 128
Eval thread interface ring buffer pending entries: 0
Log update buffers in use: 1377
Max log update buffers used at once: 3075
Log update buffer memory in use: 1040720
Max log update buffer memory used at once: 1242704
Updates from Log: 147163010
Conflict Resolution Blocks Allocated: 0
Memory pool cache: Empty
Last Tx to Queuer began : (1370358711) 2013/06/04 10:11:51
Last Tx to Queuer ended : (1370358713) 2013/06/04 10:11:53
Last Tx to Queuer log ID, position: 3673,431511008
Open   Tx: 0
Serial Tx: 0
Tx not sent: 1
Tx sent to Queuer: 22231605
Tx returned from Queuer: 22231605
Events sent to Queuer: 334
Events returned from Queuer: 334
Total rows sent to Queuer: 80857053
Open Tx array size: 1024
Complete log ID, position: 3339,744452120
.....
Table 't9880wip' at 0x3d8ef7028 [ CDRShadow ]
Table 't9800dbaudit' at 0x3d8e5b028 [ CDRShadow ]
Table 't9810dbname_001' at 0x3d8f10028 [ CDRShadow ]
.....

Grouper Table Partitions:
.....
  Slot   78...
    't9800dbaudit' 33554510
  Slot  111...
.....
    't9880wip' 33554543
.....
Repl links on global free list: 1659
Evaluators: 8
  Evaluator at 0x3d83d5050 ID 0 [Idle:Idle] Protection: unused
    Eval iteration: 20685037
    Updates evaluated: 15629507
    Repl links on local free list: 97
    UDR environment table at 0x3d83d50e0
        Number of environments:          0
        Table memory limit    :      69632
        Table memory used     :          0
        SAPI memory limit     :     131072
        SAPI memory used      :          0
        Count failed UDR calls:          0
  Evaluator at 0x3d83af488 ID 1 [Idle:Idle] Protection: unused
    Eval iteration: 20652617
    Updates evaluated: 15608214
    Repl links on local free list: 154
    UDR environment table at 0x3d83af518
        Number of environments:          0
        Table memory limit    :      69632
        Table memory used     :          0
        SAPI memory limit     :     131072
        SAPI memory used      :          0
        Count failed UDR calls:          0
.....

In the example below, the grouper evaluated and queued 22238694 transaction to the send queue. The Tx sent to Queuer field shows the total number of transactions evaluated and queued to the send queue for propagating to all the replicate participants. The Total rows sent to Queuer field shows the total number of rows queued to the send queue for propagating to all the replicate participants.

onstat -g grp T

Last Tx to Queuer began : (1370359030) 2013/06/04 10:17:10
Last Tx to Queuer ended : (1370359030) 2013/06/04 10:17:10
Last Tx to Queuer log ID, position: 3673,496591740
Open   Tx: 0
Serial Tx: 0
Tx not sent: 1
Tx sent to Queuer: 22238694
Tx returned from Queuer: 22238694
Events sent to Queuer: 334
Events returned from Queuer: 334
Total rows sent to Queuer: 80872695
Open Tx array size: 1024
Complete log ID, position: 3339,744452120

In the example below, the pager status. Enterprise Replication uses a grouper paging mechanism for evaluating large transactions. A transaction is large if the portion to be replicated meets one of the following conditions:

      It exceeds one fifth the size of the value of the CDR_QUEUEMEM ONCONFIG variable.
      It exceeds one tenth the size of the value of the SHMVIRTSIZE configuration variable.

Pre V11 big transaction also include transactions of 5000 and more log records


HCL OneDB Server Version 2.0.1.1 -- On-Line -- Up 48 days 21:55:26 -- 4536768 Kbytes
Grouper Pager statistics:
Number of active big transactions: 0
Total number of big transactions processed: 0
Spool size of the biggest transaction processed: 0 Bytes


To discuss how Oninit ® can assist please call on +1-913-674-0360 or alternatively just send an email specifying your requirements.