Live INGRES Database Session Monitoring via OpenRoad

Have you ever wondered if it is possible to actually monitor your INGRES database for possible deadlocks, runaway sessions (with the <ANY> or <OTHER> lock status)?  Could it be possible to terminate locking sessions via an OpenRoad image Well, in that case you're in luck, LOL.

This project was mainly created for those two reasons stated above.   Anyone who has used IPM before will understand that with hundreds of open sessions in the database it is almost impossible to pinpoint a culprit session holding a lock and is causing havoc with your daily grind. :P 

With this utility you can actually locate the locking session, and decide whether to terminate it or inform the session user of the problem.  Well, actually you don't even need to look for the session using the image per se - the image itself determines the session. :)  And that makes all the difference!  Imagine - no more downtimes because of a long and determined search for that nuisance session.  No undue stress because of the pressure from higher-ups to make quick and do jumping jacks if by-all-means that solves the problem. LOL.  You don't have to do anything at all, the program has a built-in alarm system which will inform you via the frame and a literal alarm if you opt to use the audio component of the image. 

The audio component by the way is another creation of mine, it is actually a 3GL wapper DLL (WinAPI.DLL) for various Windows thingamagigs.  You may find it very useful if you want INGRES to do something else than the usual stuff. 

Now for the files you need:

1. The DLL along with the 3GL wrapper export file ang the manual are in WinAPI.ZIP.
2. The actual images for monitoring (dbmon35.exp and dbmon41.exp) as in Images.ZIP.

Note: I only compiled for OR 3.5 and 4.1 but if needed I can make images for OR 2006 and OR5 if I can get my hands on those. LOL.  Anyways the 4.1 image seems to work on higher versions thanks to backward compatibilites between these versions.

3. The manual to get you started - DBMonitor.PDF.

Don't take my word for it, if you have a spare server/database you can always test if the image actually works.  One important note though, you will have to do some tinkering with your IMADB to make this image work.  The procedure is there in the manual, and it slightly varies with different installations.  A little hassle in exchange for a life of INGRES DBA bliss and peace of mind. :D

So there... If you have any trouble making the thing work, you can always contact me for more info.

BTW, the DLL and images are completely free, but if you find them useful in your daily DBA life you may donate thru my Paypal Account:

Below is a screenshot of the images main frame, all others are in the manual.  Happy monitoring!