Re: Detailed Status of Locks ?
Jens Ebert wrote:
>
> Hi,
>
> does someone has or knows abour a nice tool to show all the
> locks set on certain objects in a Onlien database?
>
> I would like to see who owns the locks and what kind of locks
> they are.
In informix 7.xx:
select * -- Or whatever you are interested in.
from sysmaster:syslocks lock, sysmaster:syssessions sess
where lock.owner = sess.sid
and dbsname = "MYDATABASE"
and tabname = "MYTABLE";
Art S. Kagel