DB2 锁
(1) update switchs:update monitor switches using bufferpool on lock on sort on statement on table on uow on
(2) Get Snapshot:
get snapshot for all on <db name>
(3) Search for specific information in the snapshot result:
假如是 Windows 环境 :
findstr /C:"Deadlocks detected" snap.out | findstr /V /C:"= 0" -- 英文版本
findstr /C:" 检测到死锁 " snap.out | findstr /V /C:"= 0" -- 中文版本
假如是 UNIX 环境 :
grep -n "Deadlocks detected" snap.out | grep -v "= 0" | more
详细信息请链接本文出处检查缓存池命中率和死锁
常见DB2锁等待解决流程
页:
[1]