DB2数据库查询是否锁表

admin

1.查询是否有锁表：                                                                                          
SELECT * FROM TABLE (SNAP_GET_LOCK ('', -1)) AS T WHERE lock_object_type = 'TABLE_LOCK'

2.查询所有被锁的表

SELECT 'CALL SYSPROC.ADMIN_CMD("force application('||agent_id||')");' FROM TABLE (SNAP_GET_LOCK ('', -1)) AS T WHERE lock_object_type = 'TABLE_LOCK' ;

3.解锁：
CALL SYSPROC.ADMIN_CMD('force application(18975)');
CALL SYSPROC.ADMIN_CMD('force application(18993)');