onstat -g rcv: Print statistics about the receive manager

Prints statistics about the Enterprise Replication receive manager. The receive manager is a set of service routines between the receive queues and data sync. The onstat -g rcv command is used primarily as a debugging tool and by HCL Software Support. If you suspect that acknowledgment messages are not being applied, you can run this command.

Syntax


1  onstat -g rcv
1 serverid
1 full

The serverID option specifies a replication server.

The full option prints all statistics.

The following table describes the fields in the Receive Manager global section of the onstat -g rcv command output.
Table 1. Receive Manager section of the onstat -g rcv output
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 acknowledgments that are received but not yet processed
The Receive Parallelism Statistics section of the onstat -g rcv command output shows a summary of the data sync threads by source server.
Table 2. Receive Parallelism Statistics section of the onstat -g rcv output
Field Description
Server Source server ID
Concur Number of transactions currently being applied in parallel
Tot.Txn. Total number of transactions that are 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 transactions 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 output shows the following information for each source server. For each replicate ID:
  • The number of transactions that are applied from the source servers
  • The number of inserts, deletes, and updates within the applied transactions
  • The timestamp of the most recently applied transaction on the target server
  • The timestamp of the commit on the source server for the most recently applied transaction
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 2010
    cdrRM_DSCreateStamp: Wed Sep 08 14:16:35 2010
    cdrRM_acksInList:         0
    cdrRM_BlobErrorBufs:      0

	Receive Parallelism Statistics
	Server Concur Tot.Txn. Pending Active MaxPnd MaxAct  AvgPnd  AvgAct CommitRt
	     1      8       1        0      0      1      1    1.00    1.00     0.06
	
	Tot Pending:0     Tot Active:0  Avg Pending:1.00    Avg Active:1.00   
	Commit Rate:0.06   
	
	Time Spent In RM Parallel Pipeline Levels
	Lev. TimeInSec  Pcnt.
	   0        40 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 
	65551       1       0       0       2 2012/10/29 09:52:23 2012/10/29 09:52:22
	
	No Replicates Currently Being Throttled
If a replicate encounters a deadlock situation or otherwise reduces the degree of parallelism by which transactions are applied, the Statistics by Source section shows the replicate and the maximum number of concurrent transactions that are possible.
	Statistics by Source
	
	Server 1
	Repl      Txn     Ins     Del     Upd Last Target Apply   Last Source Commit 
	65551       1       0       0       2 2012/10/29 09:52:23 2012/10/29 09:52:22
	
	Replicates Being Throttled
	Repid      Max
	           Concurrent
	65551      3
If the replicate includes a TimeSeries column, a TimeSeries Statistics by Source section shows statistics about the time series elements that are applied on target servers:
TimeSeries Statistics by Source

Server 100
Repl        Txn   TSIns   TSDel   TSCmd Last Target Apply   Last Source Commit 
65536       672     672       0       0 2012/08/27 15:04:33 2012/08/27 15:04:32