Lock event reporting has been enhanced

In Version 9.7, there are new approaches for collecting lock event reports, using data captured by the new lock event monitor (CREATE EVENT MONITOR FOR LOCKING). You can use this data to help identify and resolve lock wait, lock timeout, and deadlock problems.

The new lock event monitor contains many additional monitor elements and is a more efficient method to collect lock-related events than the previous methods. The new approach collects information about lock timeouts, deadlocks, and lock waits that are more than a specified duration. The previous methods included using the DB2DETAILDEADLOCK event monitor, the DB2_CAPTURE_LOCKTIMEOUT registry variable, and the CREATE EVENT MONITOR FOR DEADLOCKS statement, all of which are now deprecated.