Using the rs_dump_stats procedure

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

NoteComments 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*