DB2 10.5 for Linux, UNIX, and Windows

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.