Re: Monitoring lock tables

Leonid Vorontsov wrote: > 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? I don't know. Perhaps it means that someone has acquired a few more locks between the time you issued the query, and the time you did the onstat -k? Mine show the same number of locks. Why don't you post your results here so we can see. June -- june_t@hotmail.com Lost in the wilds of Palo Alto, living on Oreo's