db2如何确定某张表是否有锁？
摘要：
转自：http://www.db2china.net/club/archiver/tid-10129.html参考：----查看SAMPLE库上表的锁数量SELECT TABSCHEMA, TABNAME, COUNT(*) AS NUMBER_OF_LOCKS_HELD FROM SYSIBMADM.LOCKS_HELD --WHERE DB_NAME = 'SAMPLE' GROUP BY DBPARTITIONNUM, TABSCHEMA, TABNAME----查询数据库锁表信息db2 "select agent_id, tabschema,tabname f 阅读全文
posted @ 2012-06-20 13:02 王培 阅读(2221) 评论(0) 推荐(0) 编辑
