今天有个表锁了。我就查看一下哪些表锁了。使用db2top命令的U选项,就死在那里不动了。
使用select distinct tabname ,agent_id ,lock_mode from sysibmadm.snaplock; 也报错。
使用db2 get snapshot for locks on dbname命令,就报错SQL1635N。
SQL1635N The snapshot operation failed because the size of the snapshot is
"2147483136" bytes, which exceeds the maximum allowable size of "2147483135"
bytes.
我怎么样才能查询到锁表的ID,进而删掉呢?