Re: Monitoring lock tables
June Tong wrote:
...
> select username, sid, dbsname, tabname, l.lk_type lock_type, l.lk_kvobj
> rowid, lk_keynum key_num
> from sysrstcb r, syslocktab l, systabnames t
> where r.txp = l.lk_owner
> and t.partnum = l.lk_partnum...
The 'onstat -k' command shows 2 locks more than Your select.
What this mean?
Leonid.