`

DB2查询锁及解锁

 
阅读更多

查询所有锁表信息:

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

根据agent_id进行解锁操作:

FORCE application (agent_id);


分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics