rs_dump_stats dumps the contents of the rs_statrun and rs_statdetail system tables to a CSV file that can be loaded into a spreadsheet for analysis. For complete syntax and usage information for rs_dump_stats, see the Replication Server Reference Manual.
To use rs_dump_stats, log in to the RSSD and execute the stored procedure. For example:
1> rs_dump_stats 2> go
Comments to the right of the output are included to
explain the example. They are not part of the rs_dump_stats output.
Comment: Sample of rs_dump_stats output
Nov 5 2005 12:29:18:930AM *Start time stamp*
Nov 5 2005 12:46:51:350AM *End time stamp*
16 *No of observation intervals*
1 *No of min between
observations*
16384 *SQM bytes per block*
64 *SQM blocks per segment*
CM *Module name*
13 *Instance ID*
-1 *Instance value*
dCM *Module name*
CM: Outbound database connection request *Counter external name*
CMOBDBReq *Counter display name*
13003 , , 13, -1 *Counter ID, instance ID,
instance value*
ENDOFDATA *EOD for counter*
CM: Outbound non-database connection requests *Counter external name*
CMOBNonDBReq *Counter display name*
13004 , , 13, -1 *Counter ID, instance ID,
instance value*
Nov 5 2005 12:29:18:930AM, 103, 103, 1, 1 *Dump ts, obs, total,
last, max*
Nov 5 2005 12:30:28:746AM, 103, 103, 1, 1
Nov 5 2005 12:31:38:816AM, 107, 107, 1, 1
Nov 5 2005 12:32:49:416AM, 104, 104, 1, 1
Nov 5 2005 12:33:58:766AM, 114, 114, 1, 1
...
Nov 5 2005 12:46:51:350AM, 107, 107, 1, 1
ENDOFDATA *EOD for counter*
CM: Outbound 'free' matching connections found *Counter external name*
CMOBFreeMtchFound *Counter display name*
13005 , , 13, -1 *Counter ID, instance ID,
instance value*
Nov 5 2005 12:29:18:930AM, 103, 103, 1, 1 *Dump ts, obs, total,
last, max*
Nov 5 2005 12:30:28:746AM, 103, 103, 1, 1
...
Nov 5 2005 12:46:51:350AM, 2, 2, 1, 1
ENDOFDATA *EOD for counter*
