Interpreting event alarm messages

Some of the events that the database server reports to the message log trigger the alarm program. The class messages indicate the events that the database server reports.

The database server reports a nonzero exit code in the message log. In the alarm program, set the EXIT_STATUS variable to 0 for successful completion and to another number for a failure.

For example, if a thread attempts to acquire a lock, but the maximum number of locks are already in use, the database server writes the following message to the message log:
10:37:22  Checkpoint Completed:  duration was 0 seconds.
10:51:08  Lock table overflow - user id 30032, rstcb 10132264
10:51:10  Lock table overflow - user id 30032, rstcb 10132264
10:51:12  Checkpoint Completed:  duration was 1 seconds.

When the database server runs the alarmprogram.sh or alarmprogram.bat program, or your alarm program, the database server generates a message that describes the severity and class of the event. If the severity is greater than 2, the message takes the following format:

Action Message
A reasonably severe server event
Severity: 3
Class ID: 21
Class msg: Database server resource
      overflow: 'Locks'.
Specific msg: Lock table overflow - 
      user id 30032, rstcb 10132264 
See Also: # optional message
Event ID: 21005
The message that appears at the end of each e-mailed message
This e-mail was generated by the server
ALARMPROGRAM script on servername
because something untoward just happened
to eventname.

Copyright© 2019 HCL Technologies Limited