Tracking locks

Hi all, WHen I try to have a lock on the table in exclusive mode there could still be users accessing the table using ISOLATION DIRTY READ which does not attempt to acquire a shared lock on a table or its records. So I am looking how to track those users because I think that onstat don't do that. Thanks for any suggestion

> Hi all, > WHen I try to have a lock on the table in exclusive mode there could still > be users accessing the table using ISOLATION DIRTY READ which does not > attempt to acquire a shared lock on a table or its records. So I am looking > how to track those users because I think that onstat don't do that. Maybe you could give the following select a try: SELECT scs_sessionid, username FROM sysmaster:informix.syssqlcurses, sysmaster:informix.syssessions WHERE scs_sessionid = sid AND scs_sqlstatement MATCHES "*your_table_name*" Bye, Chris