1、死锁事件监控器是db2每个数据库缺省建立的监视器,写文件的形式,存放路径在db2event目录下,如:
windows:
unix:
2、分析死锁监视器
windows:
F:/>cd F:/DB2_WZGL/NODE0000/SQL00001/DB2EVENT/db2detaildeadlock
F:/>db2 set event monitor db2detaildeadlock state=0
DB20000I SQL 命令成功完成。
F:/>db2evmon -path F:/DB2_WZGL/NODE0000/SQL00001/DB2EVENT/db2detaildeadlock>deadlock.txt
Reading F:/DB2_WZGL/NODE0000/SQL00001/DB2EVENT/db2detaildeadlock/00000000.EVT ...
F:/>db2 set event monitor db2detaildeadlock state=1
DB20000I SQL 命令成功完成。
unix:
$ find . -name db2detaildeadlock
./inst16/NODE0000/SQL00001/db2event/db2detaildeadlock
$ db2evmon -path ./inst16/NODE0000/SQL00001/db2event/db2detaildeadlock>lock16.txt
Reading ./inst16/NODE0000/SQL00001/db2event/db2detaildeadlock/00000000.evt ...
Reading ./inst16/NODE0000/SQL00001/db2event/db2detaildeadlock/00000001.evt ...
$
$ grep "Deadlock detection time:" lock16.txt
Deadlock detection time: 06/10/2008 11:42:04.580880
Deadlock detection time: 06/10/2008 11:42:04.594876
Deadlock detection time: 06/10/2008 11:42:04.608274
Deadlock detection time: 06/10/2008 11:42:05.594945
Deadlock detection time: 06/10/2008 11:42:05.595020
Deadlock detection time: 06/10/2008 11:42:05.610197
.....
2、分析死锁监视器
--------------------------------------------------------------------------
Database Name: WZGL
Database Path: F:/DB2_WZGL/NODE0000/SQL00001/
First c