IIUG Software Repository Files

Program: ratios
Author:  David Kleppinger     dkleppinger@dts.edu


Perl script to calculate Read-ahead utilization, Bufwaits Ratio, and
Buffer Turnover ratio.

Usage: ratios [<profile> [<period>]]
    If no parameters given it runs onstat -p to get the current profile
    information and does it's calculations.

    <profile> is the name of a file containing the output of a
    previously run onstat -p.  If a <period> is given it will calculate
    the BTR base on <period> minutes since reset.


Warnings:

Uses onstat -c to get BUFFERS.  If BUFFERS has been changed recently it
will report BR/BTR incorrectly when run on a <profile> file created
before the change.

If no parameters are given it requires Jonathan Leffler's sqlcmd to get
the time since last reset of the statistics.

Future development: Use SMI tables directly instead of onstat.
                    Use DBI::Informix instead of onstat/sqlcmd.
		    Allow BUFFERS to be passed as a parameter.