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

On 4 Feb 1997, Vijay Anisetti 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 > > try select * from syslocks;You will get database name, tablename, rowid, keynum and owner. owner will be sesid. Lookit up using syssessions which gives the user name for that ses id. refer to INFORMIX-online DSA guide page 39-16. for syslocks and page 39-23 for syssessions ################################################################ Rajeev Nimmagadda SRK rajeevn@jcdcrs4.jobcorps.org # (512)393-7204