IIUG Software Repository Files

From: jparker@hpbs3645.boi.hp.com (Jack Parker)
Newsgroups: comp.databases.informix
Subject: DBAmon - Engine monitor
Date: 1 Apr 1994 15:03:43 -0500

Folks,

Some time ago I wrote a monitor to track engine performance and tell the DBA
of problems.  Mike Alder has since made several enhancements to it.  This is
an update of the one I posted previously (probably about a year ago).  I
asked for and received permission to make this public as payment for all 
the help I've received from the net.  Please note it makes extensive use of
awk which may not work the same way on other platforms.  Also note that if
it blows up your data - that's your problem not mine.  No warranties expressed
or implied.

As always - any comments or suggested improvements would be welcome.

Synopsis:
DBAmon - Database engine monitor
Rating: B+
Author: JParker/Mike Alder
Tested under: HP - Online 5.0
Pro: has saved our bacon a number of times.
Con: is a resource hog, it dumps a memory image (later cleaned up) which can
     be rather large.

     DBAmon reads a file (online.engines) to determine what engines are running
     on a platform and then performs a tbstat against each engine and performs a
     number of checks to ensure:

     a) that the engine is running
     b) that the IStar deamon is running (configurable)
     c) checks installation permissions (uses ckfls)
     d) check performance against user-defined thresholds
     e) check logfiles for errors
     f) check chunk status != PD or MD
     g) check log files backup (only applicable when performed to disk)
     h) check for resource hogs or DOA users
     i) is a tbtape -c running (configurable)
     j) check for free system memory
     k) check for disabled page cleaners
     l) check for free dbspace
     m) check disk fragmentation
     n) check for logfile errors
     o) check Online reserved pages

Results are mailed to the $DBA.