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

Vijay Anisetti <rambabu@sprynet.com> wrote in article <01bc125f$4e3f5de0$f0a8aec7@vijay>... > > 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. Check out the "Informix Tips and Information" pages at http://www.objectsoft.com . You'll find a script there named "onlocks" which queries the SMI tables in the sysmaster database for a more user-friendly version of the listing which "onstat -k" provides. Real user names and table names are displayed rather than hex addresses and you can filter the list by user name, table name, database name, etc. HTH -- Irwin Goldstein Objective Software Systems, Inc. http://www.objectsoft.com