If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
I am looking for a script to monitor the informix dataase on unix which can alert(email/pager) the DBA incase the database goes to any other mode other than 'online' mode i.e if the database goes down for normal users or goes down completely.
You can use Informix's shell script ALARMPROG name is log_full.sh as default name this script can action as you want . It's event-base action , In my site I use it with my monitoring shell script with crontab togather
If you do that, you should make your logfiles not too big.
This shell script is fired when the LOG Full event is enabled.
It can take a while when you don't do a lot of updates in your database.