实例讲解如何在DB2 UDB中正确的监控死锁

---------------------------------
EVENT LOG HEADER  Event Monitor name: 
DLMON  Server Product ID: SQL08022……  Server instance name: DB2
--------------------------------------
--------------------------------------
 Database Name: SAMPLE    Database Path:
 C:\DB2\NODE0000\SQL00001\	……------------------3)
Deadlock Event ...  Deadlock ID:   1	……4) 
Connection Header Event ...  Appl Handle: 949	……5) 
Deadlocked Connection ...  Deadlock ID:   
1  Participant no.: 
2  Participant no. holding the lock: 1  Appl Id: 
G9B56A72.HE13.01B406083205  Appl Seq number: 0001  
Appl Id of connection holding the lock: 
G9B56A72.HD13.02CE06083152	……  Deadlock detection 
time: 2006-01-06 16:34:27.327582  Table of lock waited on: 
EMPLOYEE	(A锁发生的表)  Schema of lock waited on: 
JT        Tablespace of lock waited on : USERSPACE1  
Type of lock: Row	（A锁级别为行锁）  Mode of lock: 
X   - Exclusive	（A锁模式为排他锁）  Mode application 
requested on lock: NS - Share (and Next Key Share)	
（在A排他锁上要求B共享锁，发生死锁）	……Text: 
select name from employee（产生B共享锁的SQL语句）  
List of Locks:	（当前所有锁的列表）……      Lock Name 
: 0x020005000D0000000000000052      Lock Attributes: 0x00000008
Release Flags               : 0x40000000      Lock Count 
: 1      Hold Count                  : 0      Lock Object Name 
: 13      Object Type  : Row      Tablespace Name: USERSPACE1
Table Schema                : JT            Table Name
: PROJECT      Mode                        : X   - Exclusive
（在PROJECT表上有一个排他锁）……      Lock Name:
 
0x02000300000000000000000054      Lock Attributes：
0x00000000    Release Flags: 0x00000001      Lock Count
: 1      Hold Count                  : 0      
Lock Object Name            : 3      Object Type: 
Table      Tablespace Name: USERSPACE1      Table Schema: 
JT            Table Name: EMPLOYEE      Mode
: IS  - Intent Share（在EMPLOYEE表上有一个共享锁）  
Locks Held: 6  Locks in List: 6……9) Table Event...  
Table schema: JT        Table name: EMPLOYEE  Record
is the result of a flush: FALSE  Table type: User  
Data object pages: 1……  Rows read: 35  Rows written: 
1	……  Tablespace id: 2  Table event timestamp: 
2006-01-06 16:37:28.972501	（记录EMPLOYEE表上发生的事件）