Re: How to find who locked what tables in 7.13 ?

On 4 Feb 1997 05:50:43 GMT, "Vijay Anisetti" <rambabu@sprynet.com> wrote: > >Friends, > >Is it possible to find the table names locked and by whom using the system >tables, sysmaster database or using any of the utilities of informix? I was >not able to map the session-id(s) (onstat) of a user to a table(s), this >might look like a wild mapping, but I just wanted to know if it is >possible. > >Vijay > The output of onstat -k will give you the partnum of the lock, this maps directly to locked resource, partnums that end in 0 are tables and reference the systables table. this is all from memory so look it up in the Sysadmin manual, but it's there, including how to convert partnum to a table identfier. Michael