The onstat -g grp command prints statistics about the grouper. 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 -g grp option is used primarily as a debugging tool and by Technical Support.
The onstat -g grp command has the following formats:
onstat -g grp onstat -g grp modifier
The following table describes the values for modifier.
| 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. |
The rest of this section contains sample output from various onstat -g grp modifier commands. The following sample shows output for the onstat -g grp command.
IBM Informix Dynamic Server Version 10.00.UC1 -- On-Line -- Up 01:47:07 -- 28672 Kbytes
Grouper at 0xb014018:
Last Idle Time: (1095122236) 2004/09/13 19:37:16
RSAM interface ring buffer size: 528
RSAM interface ring buffer pending entries: 0
Eval thread interface ring buffer size: 48
Eval thread interface ring buffer pending entries: 0
Log update buffers in use: 0
Max log update buffers used at once: 5
Log update buffer memory in use: 0
Max log update buffer memory used at once: 320
Updates from Log: 16
Log update links allocated: 512
Blob links allocated: 0
Conflict Resolution Blocks Allocated: 0
Memory pool cache: Empty
Last Tx to Queuer began : (1095118105) 2004/09/13 18:28:25
Last Tx to Queuer ended : (1095118105) 2004/09/13 18:28:25
Last Tx to Queuer log ID, position: 12,23
Open Tx: 0
Serial Tx: 0
Tx not sent: 0
Tx sent to Queuer: 2
Tx returned from Queuer: 2
Events sent to Queuer: 7
Events returned from Queuer: 7
Total rows sent to Queuer: 2
Open Tx array size: 1024
Table 'tab' at 0xae8ebb0 [ CDRShadow ]
Table 'tab12' at 0xae445e0 [ CDRShadow ]
Grouper Table Partitions:
Slot 312...
'tab' 1048888
Slot 770...
'tab12' 3145730
Slot 1026...
'tab12' 4194306
Repl links on global free list: 2
Evaluators: 3
Evaluator at 0xb03d030 ID 0 [Idle:Idle] Protection:unused
Eval iteration: 1264
Updates evaluated: 0
Repl links on local free list: 256
UDR environment table at 0xb03d080
Number of environments: 0
Table memory limit : 25165
Table memory used : 0
SAPI memory limit : 131072
SAPI memory used : 0
Count failed UDR calls: 0
Evaluator at 0xb03d0d8 ID 1 [Idle:Idle] Protection:unused
Eval iteration: 1265
Updates evaluated: 2
Repl links on local free list: 254
UDR environment table at 0xb03d128
Number of environments: 0
Table memory limit : 25165
Table memory used : 0
SAPI memory limit : 131072
SAPI memory used : 0
Count failed UDR calls: 0
Evaluator at 0xb03d180 ID 2 [Idle:Idle] Protection:unused
Eval iteration: 1266
Updates evaluated: 4
Repl links on local free list: 256
UDR environment table at 0xb03d1d0
Number of environments: 0
Table memory limit : 25165
Table memory used : 0
SAPI memory limit : 131072
SAPI memory used : 0
Count failed UDR calls: 0
Total Free Repl links 768
Replication Group 6553601 at 0xb0a8360
Replication at 0xb0a82b0 6553601:6553601 (tab)
[ NotifyDS FullRowOn ]
Column Information [ CDRShadow VarUDTs InOrder Same ]
CDR Shadow: offset 0, size 8
In Order: offset 8, size 10
Replication Group 6553602 at 0xb0a8480
Replication at 0xb0a83d0 6553602:6553602 (tab12)
[ Ignore Stopped NotifyDS FullRowOn ]
Column Information [ CDRShadow VarUDTs InOrder Same ]
CDR Shadow: offset 0, size 8
In Order: offset 8, size 16
The following example shows output for the onstat -g grp E command. The field Evaluators: 4 indicates that there are four evaluation threads configured for the system.
IBM Informix Dynamic Server Version 10.00.UC1 -- On-Line -- Up 02:07:10 -- 36864 Kbytes
Repl links on global free list: 0
Evaluators: 4
Evaluator at 0xba71840 ID 0 [Idle:Idle] Protection: unused
Eval iteration: 1007
Updates evaluated: 0
Repl links on local free list: 256
UDR environment table at 0xba71890
Number of environments: 0
Table memory limit : 16777
Table memory used : 0
SAPI memory limit : 131072
SAPI memory used : 0
Count failed UDR calls: 0
Evaluator at 0xba718f0 ID 1 [Idle:Idle] Protection: unused
Eval iteration: 1007
Updates evaluated: 0
Repl links on local free list: 256
UDR environment table at 0xba71940
Number of environments: 0
Table memory limit : 16777
Table memory used : 0
SAPI memory limit : 131072
SAPI memory used : 0
Count failed UDR calls: 0
Evaluator at 0xba8c260 ID 2 [Idle:Idle] Protection: unused
Eval iteration: 1007
Updates evaluated: 0
Repl links on local free list: 256
UDR environment table at 0xba8c2b0
Number of environments: 0
Table memory limit : 16777
Table memory used : 0
SAPI memory limit : 131072
SAPI memory used : 0
Count failed UDR calls: 0
Evaluator at 0xbaac2a0 ID 3 [Idle:Idle] Protection: unused
Eval iteration: 1007
Updates evaluated: 0
Repl links on local free list: 256
UDR environment table at 0xbaac2f0
Number of environments: 0
Table memory limit : 16777
Table memory used : 0
SAPI memory limit : 131072
SAPI memory used : 0
Count failed UDR calls: 0
Total Free Repl links 1024
The following example shows output for the onstat -g grp G command.
IBM Informix Dynamic Server Version 10.00.UC1 -- On-Line -- Up 02:08:56 -- 36864 Kbytes
Grouper at 0xb8ab020:
Last Idle Time: (1095115397) 2004/09/13 17:43:17
RSAM interface ring buffer size: 1040
RSAM interface ring buffer pending entries: 0
Eval thread interface ring buffer size: 64
Eval thread interface ring buffer pending entries: 0
Log update buffers in use: 0
Max log update buffers used at once: 1
Log update buffer memory in use: 0
Max log update buffer memory used at once: 64
Updates from Log: 1
Log update links allocated: 512
Blob links allocated: 0
Conflict Resolution Blocks Allocated: 0
Memory pool cache: Empty
The following example shows output for the onstat -g grp P command. In the following example, the grouper is evaluating rows for the account, teller and customer tables.
IBM Informix Dynamic Server Version 10.00.UC1 -- On-Line -- Up 02:11:39 -- 36864 Kbytes
Table 'teller' at 0xb851480 [ CDRShadow VarChars ]
Table 'account' at 0xb7faad8 [CDRShadow VarChars VarUDTs Floats
Blobs]
Table 'customer' at 0xbbe67a8 [CDRShadow VarChars VarUDTs]
Grouper Table Partitions:
Slot 387...
'account' 1048707
Slot 389...
'teller' 1048709
Slot 394...
'customer' 1048714
The following example shows output for the onstat -g grp pager command. The sample output shows the grouper large transaction evaluation statistics.
IBM Informix Dynamic Server Version 10.00.UC1 -- On-Line -- Up 00:20:42 -- 28672 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
The following example shows output for the onstat -g grp R command. In this example, the grouper is configured to evaluate rows for replicates with IDs 6553601 and 6553602 (you can use the onstat -g cat repls command to obtain the replicate names). The Ignore attribute of replicate ID 6553602 shows that the grouper is currently not evaluating rows for this replicate. This can happen if the replicate state is not ACTIVE. You can obtain the replicate state using the onstat -g cat repls command.
IBM Informix Dynamic Server Version 10.00.UC1 -- On-Line -- Up 00:04:47 -- 28672 Kbytes
Replication Group 6553601 at 0xb0a8360
Replication at 0xb0a82b0 6553601:6553601 (tab) [ NotifyDS
FullRowOn ]
Column Information [ CDRShadow VarUDTs InOrder Same ]
CDR Shadow: offset 0, size 8
In Order: offset 8, size 10
Replication Group 6553602 at 0xb0a8480
Replication at 0xb0a83d0 6553602:6553602 (tab12) [ Ignore
Stopped NotifyDS FullRowOn ]
Column Information [ CDRShadow VarUDTs InOrder Same ]
CDR Shadow: offset 0, size 8
In Order: offset 8, size 16
The following example shows output for the onstat -g grp T command. In this example, the grouper evaluated and queued 1 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.
IBM Informix Dynamic Server Version 10.00.UC1 -- On-Line -- Up 00:14:51 -- 28672 Kbytes
Last Tx to Queuer began : (1095116676) 2004/09/13 18:04:36
Last Tx to Queuer ended : (1095116676) 2004/09/13 18:04:36
Last Tx to Queuer log ID, position: 5,3236032
Open Tx: 0
Serial Tx: 0
Tx not sent: 0
Tx sent to Queuer: 1
Tx returned from Queuer: 0
Events sent to Queuer: 0
Events returned from Queuer: 0
Total rows sent to Queuer: 1
Open Tx array size: 1024Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]