Re: Is there a Unix alarm program we can use with the Informix Log?

On Wed, 29 Jul 1998, Thomas Tatum wrote: > Is there a Unix command/script/program that I could set up to alert me when > the following is printed out in the message log? > > 16:44:59 Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem > 16:44:59 INFORMIX-Universal Server Version 9.14.UC1X4 > 16:44:59 Who: Session(17, informix@xxxxx, 22506, 0) > Thread(31, sqlexec, 0, 1) > File: mtex.c Line: 183 > 16:44:59 Action: Please notify Informix Technical Support. > 16:45:02 Blocking whole system for max 0 secs > 16:45:02 VP 4 timed out during system block, releasing > 16:45:02 VP 7 timed out during system block, releasing > 16:45:02 Releasing server from system block > [...] > 16:45:02 Releasing server from system block > 16:45:21 See Also: <path to logs>/af.1f4f3a > 16:45:21 Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem> > We are on solaris. Check out the code in the IIUG web site under the DBA section -- utils_jl. It has code for handling this sort of stuff. It was last used actively on v5.00 OnLine, so you'd probably have to fettle the code which discards messages so that you don't get to see routine messages, but otherwise, it should work. Note that it is designed to be run periodically by cron rather than being triggered when an event happens -- I don't know whether the alarmprog system can help with this sort of problem or not. Yours, Jonathan Leffler (jleffler@informix.com) #include <witticism.h> Guardian of DBD::Informix v0.59 -- see http://www.perl.com/CPAN