db2detaildeadlock
NODE0000/SQL00001/db2event/db2detaildeadlock目录中有*.evt ,*.ctl文件，
db2evmon -db PREDB -evm db2detaildeadlock >prdead.log命令后
我查看prdead.log中，文件部分内容如下：
Database Name: PREDB
Database Path: /SHAREDISK/PREDB/db2inst1/NODE0000/SQL00001/
First connection timestamp: 2011-06-25 12:59:40.402729
Event Monitor Start time: 2011-06-25 12:59:41.107211
Database Name: PREDB
Database Path: /SHAREDISK/PREDB/db2inst1/NODE0000/SQL00001/
First connection timestamp: 2011-06-25 13:00:40.403053
Event Monitor Start time: 2011-06-25 13:00:41.048191
这说明事件监控器捕捉到死锁了吧，怎么没显示死锁的相关信息呢？？
Interval for checking deadlock (ms) (DLCHKTIME) = 10000
怎么prdead.log文件中两次监控开始的时间间隔为1分钟呢？？？
db2evmon -db PREDB -evm db2detaildeadlock >prdead.log命令后
我查看prdead.log中，文件部分内容如下：
Database Name: PREDB
Database Path: /SHAREDISK/PREDB/db2inst1/NODE0000/SQL00001/
First connection timestamp: 2011-06-25 12:59:40.402729
Event Monitor Start time: 2011-06-25 12:59:41.107211
Database Name: PREDB
Database Path: /SHAREDISK/PREDB/db2inst1/NODE0000/SQL00001/
First connection timestamp: 2011-06-25 13:00:40.403053
Event Monitor Start time: 2011-06-25 13:00:41.048191
这说明事件监控器捕捉到死锁了吧，怎么没显示死锁的相关信息呢？？
Interval for checking deadlock (ms) (DLCHKTIME) = 10000
怎么prdead.log文件中两次监控开始的时间间隔为1分钟呢？？？
3同行回答
deadlock can be observed in db2diag.log收起
浏览796
谁说有死锁的？
3) Deadlock Event ...
Deadlock ID: 247
Number of applications deadlocked: 2
Deadlock detection time: 2011-11-22 09:16:04.690597
Rolled back Appl participant no: 2
Rolled back Appl Id: 99.6.137.155.20508.111121232618
Rolled back Appl seq number: : 0025
类似如上的，会存在deadlock事件。此时你也可以抓db 快照来看deadlock个数收起
3) Deadlock Event ...
Deadlock ID: 247
Number of applications deadlocked: 2
Deadlock detection time: 2011-11-22 09:16:04.690597
Rolled back Appl participant no: 2
Rolled back Appl Id: 99.6.137.155.20508.111121232618
Rolled back Appl seq number: : 0025
类似如上的，会存在deadlock事件。此时你也可以抓db 快照来看deadlock个数收起
浏览759