Download Latest Version tpc-c-ifmx.tar.gz (392.7 kB)
Email in envelope

Get an email when there's a new version of IIUG Software Repository

Name Modified Size InfoDownloads / Week
Parent folder
ratios 2019-06-13 4.1 kB
ratios.README 2019-06-13 968 Bytes
Totals: 2 Items   5.1 kB 0
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.
Source: ratios.README, updated 2019-06-13