PKB 20575 recommends using a monitoring tool to monitor the database log file.
Are there simple reliable tools on windows that can be run as a service and send a mail when certain errors occur in the database log
https://progress.my.salesforce.com/articles/Article/P3771?popup=true
The -bistall database startup parameter should be used only if there is constant management of the underlying system so that if there is a stall it can be handled immediately. Typically OpenEdge Management or 3rd party enterprise monitoring tools are configured to watch the database .lg file for the 90% and stalled messages and trigger appropriate next actions.
One option is to use Windows task scheduler. Configure a task triggered on an event where log = application, source = {dbname}_PROGRESS and event ID = progress error code i.e. 6566. On the action tab set action to send an email. If you have issues with the email server and the options in send an email then change the action to start a program where the program is a BAT file that sends an email message.
Google led me to this http://nxlog.org/ has someone already used this tool together with OpenEdge log files ?
One option is to use Windows task scheduler. Configure a task triggered on an event where log = application, source = {dbname}_PROGRESS and event ID = progress error code i.e. 6566. On the action tab set action to send an email. If you have issues with the email server and the options in send an email then change the action to start a program where the program is a BAT file that sends an email message.
Thanks for the tip. As far as I know these messages only go to the database log file, not the event log but I'll check when the event is actually generated.
Is there a similar warning for -aistall?
The database can be configured to add the messages to the event log. What version of Progress? In OpenEdge Explorer use Advanced, Windows Event Level of brief or above. (not none) eventlevel=brief
Is there a similar warning for -aistall? Yes. Look at 12288 and 12289.
(12288) There are no available EMPTY AI extents. Database activity is stalled until an AI extent becomes available.
(12289) Database activity is no longer stalled and will continue normally.
The paid version of ProTop monitors log files and a million other things. Ping me offline for more info.
Paul
"If you have issues with the email server and the options in send an email then change the action to start a program where the program is a BAT file that sends an email message."
So I've been playing around with this and the email feature is deprecated in 2012 R2, meaning you can't create tasks with this as an action. So I need to go down the .bat route, but struggling to work out how to achieve this. Any ideas please?
An email client is required. With that at hand the bat file should be straight forward.
Here are links to a few that I have run across that support command line use. I tend to sue sendemail due to the TLS support.
caspian.dotconf.net/.../SendEmail
This one has a known limit a 16 kb message. TLS support starting with version 1.54
SendEmail works a treat thanks.