查看数据库锁表信息
----查询数据库锁表信息
db2 "select agent_id, tabschema,tabname from sysibmadm.snaplock"
查看数据库某张表是否被锁:
----查询数据库锁表信息
select count(tabname) from sysibmadm.snaplock
----查询数据库锁表信息
db2 "select agent_id, tabschema,tabname from sysibmadm.snaplock"
查看数据库某张表是否被锁:
----查询数据库锁表信息
select count(tabname) from sysibmadm.snaplock