This Zip package contains the seven shells I described in my presentation at the 2002 IBM Data Management Conference. There are seven shells and the powerpoint presentation included in this package, along with this readme file. README alarm.sh checkdb.sh evidence.sh lookatspace.sh onchecks.sh prunelog.sh updstats.sh 2002DM conf_D05.ppt The powerpoint presentation gives an overview of what the shells do and how they can assist one in monitoring the health of your 7.x and/or 9.x Informix engine. The alarm shell was the primary focus of the presentation. This shell is an improved version of the "base" shell supplied by IBM/Informix, and prevents multiple alarms from flooding the system, reduces false alarms, and has other features. The lookatspace shell gives the DBA warning if a dbspace is about to fill up, even though it may appear not to be close to filling up. The other shells are used to check the database to see if it is up, run oncheck commands, prune log files, and run update statistics. The alarm.sh and evidence.sh shells should be put in the $INFORMIXIDR/etc directory. Be sure to change the onconfig file entries ALARMPROGRAM and SYSALARMPROGRAM to match the names you choose to use. The other shells can be placed in any directory you choose and then run it as often as you think it needs to run. This interval will be dependent on your installation needs. If you have any questions, please email me. I will try to answer them within a reasonable amount of time. Tom Horner thorner@s1.com