Displays information and statistics about Replication Server operations.
admin { stats | statistics } [, sysmon | "all"
| module_name [, inbound | outbound ] [, display_name ] ]
[, server[, database ] [instance_id ]
[, display |, save[, obs_interval ] ]
[, sample_period ]
Displays statistics only for those counters identified as particularly important for performance and tuning purposes. Counters are selected from nearly all modules. This is the default.
Displays statistics from all counters.
Displays statistics from the named module’s counters, where module_name is cm, dsi, dist, dsiexec, repagent, rsi, rsiuser, serv, sqm, sqt, sts, sync, and others. Use rs_helpcounter to obtain valid module names.
inbound and outbound are types of sqt or sqm. If neither inbound nor outbound is supplied for the sqt or sqm module, Replication Server reports statistics for both types of queues.
Is the name of a counter. Use rs_helpcounter to obtain valid display names. display_name is only used in conjunction with module_name.
If the statistics to be collected are related to a connection, server must be a dataserver and database must be supplied. If the statistics to be collected are related to a route, server must be a Replication Server and you are not allowed to supply database.
Identifies a particular instance of a module, such as SQT or SQM, that has multiple instances. To view instance IDs, execute admin who and view the Info column.
The instance ID 0 indicates Replication Server-wide statistics. It is the instance ID of the Replication Server.
Displays statistics on the computer screen. This is the default.
Saves statistics in the RSSD. Old sampling data is truncated or preserved, depending on the current setting of stats_reset_rssd.
Specifies the length of each observation interval during the sampling period. If you do not specify an interval, there will be only one observation interval with a length equal to the sampling period. Each observation interval must be at least 15 seconds. Format can either be a numeric value in seconds, or “hh:mm[:ss]”.
Indicates the total sampling duration. The default value is zero, which reports the current counter values. With a non-zero value, the current counter values are reset and then collected for the specified sample period. Format can either be a numeric value in seconds, or “hh:mm[:ss]”.
Collects outbound SQT statistics for connection 108 for two minutes and sends the data to the RSSD.
admin stats, sqt, outbound, 108, save, 120
Collects outbound SQT statistics for connection 108 for two hours and sends data to the RSSD. In addition, the sample period is divided into observation intervals of 30 seconds each.
admin stats, sqt, outbound, 108, save, 30, "02:00:00"
Displays statistics for the SQM and SQMR modules for the inbound queue for connection 102.
admin stats, sqm, inbound, 102
Report Time: 10/31/05 02:14:17 PM Instance Instance ID ModType/InstVal -------------------------- ----------- ---------------- SQM, 102:1 pds01.tpcc 102 1 Monitor Obs Last Max Avg ttl/obs --------------------- ------ ------ ------ ------------ #*SegsActive 1 1 1 1 ========================================================================== Instance Instance ID ModType/InstVal ------------------------------ ----------- ---------------- SQMR, 102:1 pds01.tpcc, 0 SQT 102 11 Observer Obs Rate x/sec ---------------------- ------ ---------- SleepsWriteQ 4 0
In output, prefixes that precede counter names provide
information about the counter. For example, a preceding # indicates
a counter that is not reset, even if admin stats, reset is
executed, and a preceding * indicates a counter that must
be sampled, irrespective of the setting of stats_sampling.
In this example, the SegsActive counter is always sampled and never
reset.
Collects statistics for the SleepsWriteQ counter in the SQM module.
admin stats, sqm, SleepsWriteQ
Report Time 10/31/05 02:17:03 PM Instance Observer Obs Rate x/sec ------------------------------------- ------------- ---- ---------- SQMR, 101:0 edsprs01.edbprs01, 0, DSI SleepsWriteQ 0 0 SQMR, 102:0 pds01.tpcc, 0, DSI SleepsWriteQ 0 0 SQMR, 102:1 pds01.tpcc, 0, DSI SleepsWriteQ 20 0 SQMR, 103:0 rds01.tpcc, 0, DSI SleepsWriteQ 0 0
Starts sampling and saving statistics to the RSSD for one hour and thirty minutes at 20-second intervals:
admin stats, "all", save, 20, "01:30:00"
By default, admin stats reports values for the sysmon counters.
By default, admin stats does not report counters that show 0 (zero) observation. To change this behavior, set the stats_show_zero_counters configuration parameter on.
If statistics are displayed on the computer screen, they are not stored in the RSSD. Similarly, if statistics are stored in the RSSD, they are not displayed on screen.
If you use admin stats...display_name to display statistics for a particular counter, Replication Server always displays statistics for that counter, even if stats_sampling is off and the number of observations is zero.
Use admin stats with the independent module name to collect statistics for dependent modules. You cannot collect statistics using the dependent module name in the admin stats command.
Independent module |
Dependent module |
|---|---|
Data Server Interface (DSI) |
DSI Executor (DSIEXEC) |
Stable Queue Manager (SQM) |
SQM Reader (SQMR) |
Thread Synchronization (SYNC) |
SYNC Element (SYNCELE) |
admin stats displays different information for each type of counter:
Observers – values are reported for the number of observations and the number of observations per second.
Monitors – values are reported for the number of observations, last observed value, maximum observed value, and average value.
Counters – values are reported for the number of observations, the total of all observed values, the last observed value, the maximum observed value, the average value, and the number of observations per second.
Any user may execute this command.
