环境：LINUXdb2level：DB21085I Instance "db2inst1" uses "64" bits and DB2 code release "SQL09010" with level identifier "02010107".Informational tokens are "DB2 v9.1.0.0", "s060629", "LINUXAMD64", and Fix Pack "0".问题：数据库不会检测死锁和锁超时。也就是说...
显示全部环境：LINUX
db2level：
DB21085I Instance "db2inst1" uses "64" bits and DB2 code release "SQL09010" with level identifier "02010107".
Informational tokens are "DB2 v9.1.0.0", "s060629", "LINUXAMD64", and Fix Pack "0".
问题：
数据库不会检测死锁和锁超时。
也就是说理论上应该检测到死锁和锁超时的并发上面，这个数据库没有检测出来，然后一直在锁等待。
db2 get db cfg for TSO | grep -i LOCK
Max storage for lock list (4KB) (LOCKLIST) = AUTOMATIC
Percent. of lock lists per application (MAXLOCKS) = AUTOMATIC
Interval for checking deadlock (ms) (DLCHKTIME) = 10000
Lock timeout (sec) (LOCKTIMEOUT) = 15
Block log on disk full (BLK_LOG_DSK_FUL) = NO
DB2DETAILDEADLOCK的state确认为1。
请问，DB2的死锁和锁超时检测，在什么情况下会失效，该如何检查？万望赐教。
这个数据库不是我部署的，我也对部署这个库的人很无力。
收起