mon_lck_msg_lvl - Monitoring lock event notification messages configuration parameter
This parameter controls the logging of messages to the administration notification log when lock timeout, deadlock, and lock escalation events occur.
- Configuration type
- Parameter type
- Configurable online
- Default [range]
- 1 [0 - 3]
With the occurrence of lock timeout, deadlock, and lock escalation events, messages can be logged to the administration notification log by setting this database configuration parameter to a value appropriate for the level of notification that you want. The following list outlines the levels of notification that can be set:
- Level 0: No notification of lock escalations, deadlocks, and lock timeouts is provided
- Level 1: Notification of lock escalations
- Level 2: Notification of lock escalations and deadlocks
- Level 3: Notification of lock escalations, deadlocks, and lock timeouts
The default level of notification setting for this database configuration parameter is 1.