Download Latest Version
tpc-c-ifmx.tar.gz (392.7 kB)
Get an email when there's a new version of IIUG Software Repository
| Name | Modified | Size | Downloads / Week |
|---|---|---|---|
| Parent folder | |||
| newratios.ksh | 2019-06-13 | 2.7 kB | |
| ratios.sql | 2019-06-13 | 6.4 kB | |
| ratios_1110.sql | 2019-06-13 | 6.9 kB | |
| ratios_pre10.sql | 2019-06-13 | 4.1 kB | |
| README.ratios.1st | 2019-06-13 | 2.4 kB | |
| Totals: 5 Items | 22.5 kB | 0 | |
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