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
Modifier | Action |
---|---|
A | Prints all the information printed by the G, T, P, E, R, and S modifiers |
E | Prints grouper evaluator statistics |
Ex | Prints grouper evaluator statistics, expands user-defined routine (UDR) environments |
G | Prints grouper general statistics |
L | Prints grouper global list |
Lx | Prints grouper global list, expands open transactions |
M | Prints grouper compression statistics |
Mz | Clears grouper compression statistics |
P | Prints grouper table partition statistics |
pager | Prints grouper paging statistics |
R | Prints grouper replicate statistics |
S | Prints 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.) |
Sl | Prints grouper serial list (The serial list is the list of transactions, in chronological order.) |
Sx | Prints grouper serial list, expands open transactions |
T | Prints grouper transaction statistics |
UDR | Prints summary information about any UDR invocations by the grouper threads |
UDRx | Prints 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:
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.