参考:----查看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 from sysibmadm.snaplock"
----查看锁等待
SELECT SMALLINT(AGENT_ID) AS WAITING_ID, SUBSTR(APPL_NAME, 1,10) AS WAITING_APP, SUBSTR(AUTHID,1,10) AS WAITING_USER, SMALLINT(AGENT_ID_HOLDING_LK) AS HOLDER_ID, LOCK_MODE AS HELD, LOCK_OBJECT_TYPE AS TYPE, LOCK_MODE_REQUESTED AS REQUEST FROM SYSIBMADM.LOCKWAITS
查看锁表信息
-------------
SELECT substr(TABSCHEMA,1,10), substr(TABNAME,1,20), COUNT(*) AS NUMBER_OF_LOCKS_HELD FROM SYSIBMADM.LOCKS_HELD GROUP BY DBPARTITIONNUM, TABSCHEMA, TABNAME
相关文章:
http://www.db2china.net/club/viewthread.php?tid=9782&extra=page%3D3