Show TOC

admin stats, backlogLocate this document in the navigation structure

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
  • admin stats, backlog prints this information:
    • Instance – a specific occurrence of a module.

    • Monitor – the name of the monitor or counter.

    • Obs – the number of segments or blocks observed during the observation period.

    • Last – the number of segments or blocks made during the last observation period.

    • Max – the largest number of segments or blocks observed in any observation made in the observation period.

    • Total – the sum of all the segments or blocks observed during the observation period.

  • admin stats, backlog collects data from the SQMRBacklogSeg and SQMRBacklogBlock counters.

  • A segment is 1MB and a block is 16K.

Permissions

Any user may execute this command.