1.查询锁表情况,可以获取哪个表被锁,其中agent_id为哪个DB2进程锁了表
select * from sysibmadm.locks_held with ur;
2.拿到上述的agent_id,查询具体锁表的IP和应用程序
db2 list application | grep 51604
masadic db2jcc_applica 51604 192.168.210.33.59145.1405052017 NGDB 1
3.杀掉这个进程
db2 " force application(51604)"