Package: ratios.shr
Author: Art S. Kagel
Contact: art.kagel@gmail.com
Created: December 29, 2009
Latest release: May 30, 2013

Copyright 2009-2013 by Art S. Kagel. Permission for all reasonable use is
granted without restriction.

This package includes two SQL scripts (ratios.sql & ratios_1110.sql) to
create a stored procedure in the sysmaster (SMI database) and one ksh script
(newratios.ksh) which can execute the procedure and format a pretty report.

The report calculates the basic server performance metrics which I developed
several years ago.  The interpretation of those metrics is documented in many
CDI and IIUG Forum postings as well as in the Informix FAQ.  This package is a
rewrite of the package 'ratios' published by David Kleppinger <davek@dtsbiz>.
That package interpreted onstat -p and ONCONFIG file data and so did not port
well to new releases of IDS.  This version, by embedding the data gathering in a
stored procedure, is forward compatible beginning with IDS 10.00 and adds the
ability to run the procedure manually for a quick report.  It also adds
calculation of the metrics for the individual buffer caches where a server has
more than one page size cache.

This latest release adds two new metrics, btr2 & btr3, which are an attempt to 
get a better handle on buffer cache thrashing and sizing.  Acceptable ranges for
these metrics have not been established yet.  If you use this script, I would
appreciate feedback indicating what the btr2 & btr3 values are when you otherwise
recognize that there is buffer thrashing going on.  Only by working together and 
sharing information can we become better as a community at managing our servers.

Installation is simple:

1) Install the stored procedure in each server's SMI database (sysmaster):
   dbaccess sysmaster - <ratios.sql

   If you have an older version installed, this will replace the older procedure.

   If you are running IDS version 10.00 or 11.10 you will need to run the
   ratios_1110.sql script instead to create a compatible stored procedure.

   If you are running an iDS version earlier than 10.00 use ratios_pre10.sql.

2) Install the newratios.ksh script in your path:
   cp -p newratios.ksh /local/bin
   chmod +x /local/bin/newratios.ksh

3) Run the script for each server in your system:
   INFORMIXSERVER=myserver newratios.ksh

Art S. Kagel