The onstat -g rcv command prints statistics about the receive manager. The receive manager is a set of service routines between the receive queues and data sync.
The onstat -g rcv command has the following formats:
onstat -g rcv onstat -g rcv serverid onstat -g rcv full
The serverID modifier causes the command to print only those output messages received from the replication server whose groupID is serverid. The full modifier causes the command to print all statistics.
The onstat -g rcv command includes the Receive Manager global section. In this section, the following fields have the meanings shown:
Field | Description |
cdrRM_DSParallelPL | Shows the current level of Apply Parallelism, 0 (zero) being the highest |
cdrRM_DSNumLockTimeout
cdrRM_DSNumLockRB cdrRM_DSNumDeadLocks |
Indicate the number of collisions between various apply threads |
cdrRM_acksinList | Shows acknowledgements that have been received but not yet processed |
The onstat -g rcv command includes the Receive Parallelism Statistics section, a summary of the data sync threads by source server.
Field | Description |
Server | Source server ID |
Tot.Txn. | Total number of transactions applied from this source server |
Pending | Number of current transactions in the pending list for this source server |
Active | Number of current transactions currently being applied from this source server |
MaxPnd | Maximum number of transactions in the pending list queue |
MaxAct | Maximum number of transaction in the active list queue |
AvgPnd | Average depth of the pending list queue |
AvgAct | Average depth of the active list queue |
CommitRt | Commit rate of transaction from this source server based on transactions per second |
The Statistics by Source section of the onstat -g rcv command shows the following information for each source server. For each replicate ID:
The -g rcv option is used primarily as a debugging tool and by Technical Support. If you suspect that acknowledgement messages are not being applied, you can use this option to check.
The following example shows output for the onstat -g rcv full command.
Receive Manager global block 0D452018
cdrRM_inst_ct: 5
cdrRM_State: 00000000
cdrRM_numSleepers: 3
cdrRM_DsCreated: 3
cdrRM_MinDSThreads: 1
cdrRM_MaxDSThreads: 4
cdrRM_DSBlock 0
cdrRM_DSParallelPL 0
cdrRM_DSFailRate 0.000000
cdrRM_DSNumRun: 35
cdrRM_DSNumLockTimeout 0
cdrRM_DSNumLockRB 0
cdrRM_DSNumDeadLocks 0
cdrRM_DSNumPCommits 0
cdrRM_ACKwaiting 0
cdrRM_totSleep: 77
cdrRM_Sleeptime: 153
cdrRM_Workload: 0
cdrRM_optscale: 4
cdrRM_MinFloatThreads: 2
cdrRM_MaxFloatThreads: 7
cdrRM_AckThreadCount: 2
cdrRM_AckWaiters: 2
cdrRM_AckCreateStamp:Wed Sep 08 11:47:49 2004
cdrRM_DSCreateStamp: Wed Sep 08 14:16:35 2004
cdrRM_acksInList: 0
cdrRM_BlobErrorBufs: 0
Receive Parallelism Statistics
Srvr Tot.Txn. Pnding Active MaxPnd MaxAct AvgPnd AvgAct CommitRt
1 35 0 0 21 3 7.00 1.63 0.00
5 3 0 0 1 1 1.00 1.00 0.02
6 6 0 0 1 1 1.00 1.00 0.21
Tot Pending:0 Tot Active:0 Avg Pending:5.77 Avg Active:1.50
Commit Rate:0.01
Time Spent In RM Parallel Pipeline Levels
Lev. TimeInSec Pcnt.
0 17405 100.00%
1 0 0.00%
2 0 0.00%
Statistics by Source
Server 1
Repl Txn Ins Del Upd Last Target Apply Last Source Commit
65541 23 0 1 616 2004/09/08 14:20:15 2004/09/08 14:20:15
65542 11 0 0 253 2004/09/08 14:19:33 2004/09/08 14:19:33
65545 1 0 67 0 2004/09/08 14:20:37 2004/09/08 14:20:37
Server 5
Repl Txn Ins Del Upd Last Target Apply Last Source Commit
65541 3 0 0 81 2004/09/08 16:36:10 2004/09/08 16:36:09
Server 6
Repl Txn Ins Del Upd Last Target Apply Last Source Commit
65548 6 0 0 42 2004/09/08 16:37:59 2004/09/08 16:37:58Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]