创建死锁事件监控
1、java文件存放位置
/usr/IBM/db2/V9.7/samples/java/jdbc
2、java执行程序路径
/home/db2inst/sqllib/java/jdk64/bin
3、将下面两个文件拷贝到/home/db2inst/shell/db2check目录下
cp db2evmonfmt.java /home/db2inst/shell/db2check
cp DB2EvmonLocking.xsl /home/db2inst/shell/db2check
4、配置path变量
export PATH=/home/db2inst/sqllib/java/jdk64/bin:$PATH
5、编译java文件
javac db2evmonfmt.java
6、配置db cfg
db2 "CREATE EVENT MONITOR LOCKEVMON FOR LOCKING WRITE TO UNFORMATTED EVENT TABLE (TABLE LOCKEVMON)"
/修改配置参数
db2 update db cfg for sample using MON_LOCKWAIT hist_and_values MON_DEADLOCK hist_and_values MON_LOCKTIMEOUT hist_and_values
7、启动监控
db2 set eventmonitor LOCKEVMON state=1
停止监控
db2 set eventmonitor LOCKEVMON state=0
8、执行查看结果
java db2evmonfmt -d 数据库名-ue 用户.LOCKEVMON -ftext-u 用户名-p 密码 > deadlock.txt
9、查看结果
More deadlock.txt
收起