DB2死锁解决办法(SQLCODE=-911, SQLSTATE=40001)

1.首先查看下数据库中锁的表

SELECT * FROM sysibmadm.locks_held WITH ur 

 

 

 2.使用查出的AGENT_ID进行解锁

--CALL SYSPROC.ADMIN_CMD('FORCE application(AGENT_ID)')
CALL SYSPROC.ADMIN_CMD('FORCE application(39470)')

 

 OK   so easy！