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
- Database
- 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:
- 0
- Level 0: No notification of lock escalations, deadlocks, and lock timeouts is provided
- 1
- Level 1: Notification of lock escalations
- 2
- Level 2: Notification of lock escalations and deadlocks
- 3
- Level 3: Notification of lock escalations, deadlocks, and lock timeouts
The default level of notification setting for this database configuration parameter is 1.