Update syntax, parameters, and examples section of the admin statistics, sysmon command in the Reference Manual with the following:
Displays information and statistics about Replication Server counters.
admin statistics, { module_name [, display_name] | ‘all_modules ‘ | sysmon | [, sample_period ] | ‘flush_status’}
module_name – displays statistics from all of a module’s active counters, where module_name is dsi, dsiexec, sqt, dcm, dist, rsi, sqm, sqmr, sync, syncele, repagent, mem, md, or mem_in_use. When used with display_name, module_name returns statistics from one of the module’s counters. You can obtain valid module names by using rs_helpcounter.
display_name – displays the name of a counter and is used to identify counters for RCL. You can obtain valid display names by using rs_helpcounter.
all_modules – displays statistics from all active counters.
sysmon – displays statistics for modules enabled for flushing. Only counters with sysmon status are displayed.
sample_period – is the number of seconds for the sample run.
flush_status – indicates which module’s counters are flushed or reported, either when flushing counters to the RSSD or when using admin statistics, sysmon.
Example 1 Displays information for the DSI module and connection rds03.tpcc.
The information appears in a horizontal format on your
screen – that is, the counter names are spread out horizontally
on the screen.
1> admin statistics,sysmon 2> go
Sybase Replication Server Statistics Report ========================================================================
RepServer Name: prs03 Report Time: 11/10/03 01:22:53 PM ======================================================================== RepServer Runtime Configurations -------------------------------- memory_limit: 900 init_sqm_write_delay: 1000 init_sqm_write_max_delay: 10000 sqm_write_flush: off sqt_max_cache_size: 104857600 sqt_init_read_delay: 1000 sqt_max_read_delay: 1000 sts_cachesize: 200 sqm_recover_segs: 1 smp_enable: off ======================================================================== DSI Statistics ----------------------------- Info Instance_ID Instance_Val TransTotal NgTransTotal TransSucceeded CmdGroups TransInCmdGroups CmdGroupsCommit CommitsInCmdGroup CmdsSucceed GroupsClosedBytes GroupsClosedNoneOrig GroupsClosedTranPartRule PartitioningWaits AllThreadsInUse AllLargeThreadsInUse ExecsCheckThrdLock TrueCheckThrdLock CommitChecksExceeded GroupsClosedTrans --------------- ----------- ------------ ---------- ------------ -------------- --------- ---------------- --------------- ----------------- ----------- ----------------- -------------------- ------------------------- ------------------ --------------- ----------------- ------------------ ----------------- -------------------- ----------------- 104 rds03.tpcc 104 -1 44 875 45 44 875 45 895 0 0 0 0 0 44 0 0 0 0 0 Info Instance_ID Instance_Val TransApplied NgTrans CmdsApplied TransMaxGroup MemUsedMaxGroup SysTransRead InsertsRead UpdatesRead DeletesRead ExecsWritetext TPS_Average NgTPSaverage ErrsDeadlock ErrsOutofLock SendTimeAvg DSIEBPSaverage TransAvgGroup MemUsedAvgGroup SendRPCTimeAvg DSIEResultTimeAve DSIEBatch DSIEBatchTimeAve DSIEBatchSizeMax DSIEBatchSizeAve DSIEOCmdCountAve DSIEICmdCountAve DSIEBFCommitNext DSIEBFMaxCmds DSIEBFMaxBytes DSIEFSMapTimeAve DSIESCCTimeAve DSIESCBTimeAve DSIETranTimeMax DSIETranTimeAve ----------------- ----------- ------------ ------------ ----------- ---------- ------------- --------------- ------------ ----------- ----------- ----------- -------------- ----------- ------------ ------------ ------------- ----------- -------------- ------------- --------------- -------------- ----------------- ----------- ---------------- ---------------- ---------------- ---------------- ---------------- ---------------- ------------- -------------- ---------------- -------------- -------------- --------------- --------------- 104(1) rds03.tpcc 104 1 44 875 13790 20 211161 0 3801 7899 333 0 0 0 0 0 0 29 19 154941 0 5 44 7 8182 7077 19 20 90 0 523 0 0 0 74 95
Example 2 Displays the total memory in use in bytes.
admin statistics, mem_in_use
Memory_in_Use ------------- 14215074
Example 3 Displays the value of the DSIETranTimeAve counter in the DSIEXEC module:
1> admin statistics,dsiexec,DSIETranTimeAve 2> go Info Instance_ID Instance_Val DSIETranTimeAve -------------------------- ----------- ----------- --------------- 105(1) rds04.tpcc 105 1 0 104(1) rds03.tpcc 104 1 95 101(1) edsprs03.edbprs03 101 1 0
Displays statistics information, currently available or accumulated over a specified period of time. When the option flush_status is used, admin statistics displays the current flushing status of the various modules.
Any user can execute this command.
admin stats_config_connection, admin stats_config_route, admin stats_config_module.
