ALARMPROGRAM configuration parameter

onconfig.std value

On UNIX™: $ONEDB_HOME/etc/alarmprogram.sh

On Windows™: %ONEDB_HOME%\etc\alarmprogram.bat

if not present

On UNIX: $ONEDB_HOME/etc/no_log.sh

On Windows: %ONEDB_HOME%\etc\no_log.bat

value

pathname = Full path name of the alarmprogram file.

takes effect

After you edit your onconfig file and restart the database server.

When you reset the value dynamically in your onconfig file by running the onmode -wf command.

When you reset the value in memory by running the onmode -wm command.

Usage

You can set the ALRM_ALL_EVENTS configuration parameter to specify whether the ALARMPROGRAM configuration parameter runs for all events that are logged in the MSGPATH, or only for specified noteworthy events (events greater than severity 1).

If the script that the ALARMPROGRAM configuration parameter specifies does not exist, the default alarm handler, no_log.sh or no_log.bat, is substituted. After you have the correct script in place, update the value of the ALARMPROGRAM configuration parameter to specify the script. You can make this update with the server online by using the onmode -wm command.

Instead of using the supplied scripts, you can write your own shell script, batch file, or binary program to execute events. Set ALARMPROGRAM to the full pathname of this file. The database server executes this script when noteworthy events occur. These events include database, table, index, or simple-large-object failure; all logs are full; internal subsystem failure; initialization failure; and long transactions. You can have the events noted in an email or pagermail message.

To generate event alarms, set ALARMPROGRAM to $ONEDB_HOME/etc/alarmprogram.sh or %ONEDB_HOME%\etc\alarmprogram.bat and modify the file according.