The DB2 UDB database event monitor records the occurrence of deadlocks. These are situations where two or more applications lock each other, each waiting for the other(s) to release the lock. Deadlock situations are detected automatically by DB2 UDB and resolved after a specified time period. This time period is determined by database configuration parameter DLCHKTIME . Information on the SAP work processes involved, on the database manager agent processed, and detailed lock information on the objects involved in the deadlock is provided.

For technical reasons, two event monitors are used. These are then switched on and off alternately, so that one monitor is always active. The only reliable information is that recorded by the monitor that has just been switched off. This information is displayed when the function is called.

You can switch between the event monitors using the Change Event Monitor function. When you switch between event monitors, displayed information is lost. For this reason, it is essential to save information on deadlocks. To do this, choose Save to a local file to download the displayed information to your computer.