admin stats, backlog

Description

Reports the volume of replicated transactions awaiting distribution in the inbound and outbound queues in terms of segments and blocks.

Syntax

admin {stats | statistics}, backlog

Examples

Example 1

Reports the transaction backlog for the inbound and outbound queues.

admin stats, backlog
Report Time:                10/31/05 02:17:01 PM

Instance                      Monitor          Obs  Last  Max  Avg ttl/obs
----------------------------  ---------------  ---  ----  ---  -----------
SQMR 101:0 edsprs01.edbprs01,  *SQMRBacklogSeg   0     0    0            0
      0, DSI
SQMR 102:0 pds01.tpcc,         *SQMRBacklogSeg   0     0    0            0
      0, DSI
SQMR 102:1 pds01.tpcc,         *SQMRBacklogSeg 695     3    3            1
      0, SQT
SQMR 103:0 rds01.tpcc,         *SQMRBacklogSeg   0     0    0            0
      0, DSI

==========================================================================
Report Time:                10/31/05 02:56:11 PM 

Instance                      Monitor            Obs Last Max Avg ttl/obs
----------------------------- ------------------ --- ---- --- -----------
SQMR 101:0 edsprs01.edbprs01, *SQMRBacklogBlock    0    0   0           0
      0, DSI
SQMR 102:0 pds01.tpcc,        *SQMRBacklogBlock    0    0   0           0
      0, DSI
SQMR 102:1 pds01.tpcc,        *SQMRBacklogBlock  692   50  64          29
      0, SQT
SQMR 103:0 rds01.tpcc,        *SQMRBacklogBlock  251    0   2           0
      0, DSI

==========================================================================

Usage

Permissions

Any user may execute this command.