yuanqiao 发表于 2016-11-16 08:39:33

DB2查询锁及解锁

　　查询所有锁表信息：

SELECT * FROM TABLE (SNAP_GET_LOCK ('', -1)) AS T WHERE lock_object_type = 'TABLE_LOCK'


根据agent_id进行解锁操作：
FORCE application (agent_id);
页: [1]
查看完整版本: DB2查询锁及解锁