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 | |
| The message that appears at the end of each e-mailed message | |