求db2查询锁表语句与解锁语句

[a307487821]

如题，高手帮忙解答下，要语句哦，谢谢。

[yangxiao_jiang]

db2 " select agent_id,substr(stmt_text,1,100) as statement,stmt_elapsed_time_ms from table (snapshot_statement('SAMPLE',-1)) as B
where Agent_id in (select agent_id_holding_lk from table(snapshot_lockwait('SAMPLE',-1)) as A
order by lock_wait_start_time ASC fetch first 20 rows only) order by stmt_elapsed_time_ms DESC "

要解锁的话，只能提交sql，或者终止事物，没有sql能直接解锁的。

[獨钓寒江雪]

agent_id_holding_lk 在使用它的上下文中无效？

[yangxiao_jiang]

你数据库版本是多少，我的9.7是正常的。

[zhugefung]

table (snapshot_statement('SAMPLE',-1)) 表函数只有9.7以后才有呐