
238 DB2 Performance Expert for Multiplatforms V2.2
To show the details of a deadlock, double-click the deadlock from either the
System Overview window, or the Event Exception Log. Both will open the
Deadlock Event Details window as shown in Figure 4-70. Details for each
participant in the deadlock are shown, including the statements that caused the
deadlock. If the application is still active in the system, you could go to the
Application Summary screen and drill down to see more information about it.
Figure 4-70 Deadlock Details window
Tip: In DB2 UDB V8, when you create a new database a deadlock event
monitor called DB2DETAILDEADLOCK is automat ...