Monitor Status of database

[illmatic]

Hello,

I have a more or less simple question about the general monitoring of a Progress database status running on HP-UX.

What is the best way to Monitor a database and recognize as fast as possible if the db crashs, without using Fathom and forwad it to a Monitoring Software like HP- Openview.

Of course there is the <db>.lk file and also the <db>.lg file which can be monitored.
But in case the database shuts down, because of "Buffers in lock" or similar cases these options / informations are not 100 percent significant. Furthermore I dont want to get an alert in case the database is shut down for regular reason.

So I am thinking about some methods of how to monitor sudden crashs.
Maybe there is a possibility making use of the VST's, but I just want to ask if somebody else has already some experience for this special case.
The option using the command "proutil <db> -C busy" is also not quiet useful as the only returned error codes are 6,2,0.
--> 6 in multi user mode
--> 2 in single user moe
--> 0 in case the database is down.

Thanks for any feedback in advance!

 

[TomBascom]

You might want to consider DBAppraise.

It's a subscription based monitoring, alerting and reporting tool that, IMHO, is much easier to use than Fathom. Cheaper too.