查看当前的锁以及锁的等待者(等待获取锁的会话)

select
dbsname,b.tabname,rowidr,keynum,
e.txt type,d.sid owner,g.username ownername,f.sid waiter,
h.username waitname
from syslcktab a,systabnames b,systxptab c,sysrstcb d,
sysscblst g,flags_text e, outer ( sysrstcb f , sysscblst h )
where a.partnum = b.partnum
and a.owner = c.address
and c.owner = d.address
and a.wtlist = f.address
and d.sid = g.sid
and e.tabname = 'syslcktab'
and e.flags = a.type
and f.sid = h.sid;

select
dbsname,b.tabname,rowidr,keynum,
e.txt type,d.sid owner,g.username ownername
from syslcktab a,systabnames b,systxptab c,sysrstcb d,
sysscblst g,flags_text e
where a.partnum = b.partnum
and a.owner = c.address
and c.owner = d.address
and d.sid = g.sid
and e.tabname = 'syslcktab'
and e.flags = a.type
and b.tabname='t1'