db2 update db cfg for sample using MON_LOCKWAIT hist_and_values MON_DEADLOCK hist_and_values MON_LOCKTIMEOUT hist_and_values MON_LW_THRESH 10000
db2 connect to sample
db2 "CREATE EVENT MONITOR LOCKEVMON FOR LOCKING WRITE TO UNFORMATTED EVENT TABLE (TABLE LOCKEVMON)"
db2 "ALTER WORKLOAD SYSDEFAULTUSERWORKLOAD COLLECT LOCK TIMEOUT DATA WITH HISTORY"
db2 set event monitor LOCKEVMON state=1

###Do some work here to reproduce locks.

db2 flush event monitor LOCKEVMON
db2 set event monitor LOCKEVMON state=0
db2 "ALTER WORKLOAD SYSDEFAULTUSERWORKLOAD COLLECT LOCK TIMEOUT DATA NONE"

cp /home/db2inst1/sqllib/samples/java/jdbc/db2evmonfmt.java ./
cp /home/db2inst1/sqllib/samples/java/jdbc/DB2EvmonLocking.xsl ./
export PATH=/home/db2inst1/sqllib/java/jdk64/bin:$PATH
javac db2evmonfmt.java

java db2evmonfmt -d sample -ue LOCKEVMON -ftext -ss DB2EvmonLocking.xsl -u db2inst1 -p db2inst1 > deadlock.txt
more deadlock.txt 可以看到有关的SQL语句。

http://www.ibm.com/developerworks/cn/data/library/techarticles/dm-0707fechner/index.html
http://www.ibm.com/developerworks/cn/data/library/techarticles/dm-1004lockeventmonitor/