Re: Who locks my table? Help!

Wolf P'ter wrote: > > How can I query which user lock the whole table? > Any orher people get -247, -113 when tying to update! > > I ve tried to look in the sysmaster:syslocks table, but I can't > understand it. > > Thanks any help > Peter Wolf Look at your transaction isolation level. If it is set to cursor stability or repeatable read, a select will lock rows, which then cannot be updated. See the manual for SET ISOLATION. If your database is mode ansi, it will have default isolation of repeatable read. Don't forget to commit work after selects if you have a high isolation level. -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk --- My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/