--查询被锁的表
SELECT * FROM TABLE (SNAP_GET_LOCK ('', -1)) AS T WHERE lock_object_type = 'TABLE_LOCK' ;
--解锁表 传入agent_id CALL SYSPROC.ADMIN_CMD 是在数据库工具执行命令行
CALL SYSPROC.ADMIN_CMD('FORCE application (12679)');
CALL SYSPROC.ADMIN_CMD('FORCE application all');
--整理表碎片
CALL SYSPROC.ADMIN_CMD('REORG TABLE ITP_INCIDENTS');
DB2解决锁表
最新推荐文章于 2024-05-31 12:14:58 发布