.

RS_MonitorCounters.xlsx

MS Excel 2010   Spreadsheet containing the list of all the RS Monitor Counter descriptions   (each RS version on separate tab)

.\model

RS_MonitorCounters_157.pdm

PowerDesigner 16.1 model   of the tables and procs used for analysis – essentially a subset of the RS   15.7+ RSSD

.\collect

bcp_out_rssd.bat

Sample script to bcp out   the statistics as well as relevant other system tables from the RSSD of the   monitored server

.\collect

rs_stats_cancel.rcl

Cancels any currently   running statistics collection.  Note   that it does not truncate the statistics tables in the RSSD.   This script is useful for sites that wish   to run the collection repeatedly using cron or other scheduler and find that   previous collections may bleed into next collection.

.\collect

rs_stats_collect_15x.rcl

The file containing the   RCL to turn on statistics sampling.    Only editing necessary is the length of time to collect statistics   for.

.\collect

trace_dsi_workload.rcl

A script to turn off the   DSI_WORKLOAD trace flag used to ensure AOBJ counters are collected in 15.6

.\collect

trace_rs_ticket.rcl

A script to turn on (or   off) the tracing of rs_tickets to the RS errorlog

.\collect

truncate_stats.sql

A file containing the   truncate commands to clear the statistics after a collection.  Needs to be invoked with isql   –D<RSSD_db_name>.

.\load

bcp_in_rssd.bat

Script to load the RS MC   statistics and other RSSD tables

.\load

fix_names.bat

A script created for   people who can't follow directions - attempts to rename the statistics files   bcp'd out into the specific names that the bcp in scripts expect.

.\load

gunzip_data.bat

Script to gunzip data   collected and zipped with gzip (.tgz or .tar.gz)

.\load

sample_run.sql

A script that shows   several sample execution syntaxes for both the summary and the detail report   procedures.   For the detail report,   examples demonstrating using routes are included.

.\load

truncate_tables.sql

Script to truncate the   analysis schema before loading new statistics

.\load

unix2dos_data.bat

Script to convert data   from unix to dos format (<CR/LF>)

.\load

update_statistics.sql

Script to update index   statistics after statistics are uploaded

.\setup\unix_utils

gzip_tar.zip

Zip archive containing   GNU gzip and tar utilities for MS Windows

.\setup\unix_utils

unix2dos.zip

Zip archive containing   unix2dos utility for MS Windows

.\setup

bcp_in_rs_datatype

Script to load   rs_datatype and rs_tvalues tables.    These tables are optional for analysis, but do support the reverse   engineering procedures in case you wish to see the repdef/subscription   definitions without connecting back to the production RS(s).

.\setup

drop_all_tables.sql

A script that drops all   procedures and tables from the analysis database – useful for when patching   with later versions as it removes the entire analysis schema.

.\setup

readme.txt

A quick   file explaining how to create the RS MC analysis database….for those who   didn't feel the need to read this doc.

.\setup

rep_analysis_157_db.sql

Script to create the   analysis database

.\setup

rep_mc_tables_157.sql

Script to create the   partial RSSD schema used by the analysis stored procedures

.\setup

rs_mc_analysis_procs_157.sql

Script containing the   analysis stored procedures

.\setup

rs_report_headings.sql

Script containing the   report headings for the analysis report procedures

.\setup

rs_report_explanations.sql

Script containing the   explanations for each section of the report

.\setup

truncate_log.sql

A code fragment used to   build rs_mc_analysis_procs_157.sql, but also useful for truncating the log   when necessary or desired.