RE: SE 5.02 / Locksituation

This works on Online 7 & 9 3 ways to see locks - 1) onstat -u | grep "L-" shows you the users waiting on locks (if "set lock mode to wait" was done in 4gl) You can trace this back to the owner. If you want to try this, I can send you more info 2) onstat -k shows table locks tblsnum in the output is equal to "select hex(partnum) from systables ....." Remember to use the lowercase values (not the uppercase that the select returns) Also exclude the 0x00 (the first 4 digits) from the select 3) select * from sysmaster:syslocks Regards Dirk -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Andreas Bettin Sent: Wednesday, December 13, 2000 5:48 PM To: informix-list@iiug.org Subject: SE 5.02 / Locksituation Hello! We have: Informix SE 5.02 on compaq tru64/4.0E on alpha workstation 500 with 256 MB Ram. We have 5-10 Users on the same table (table customers with 500000 Rows). The program is written in 4GL. Problem is, that the table is locked for all users from time to time. If I try to insert/update a row over dbaccess, I become the message "Table is locked". But all users not in transactions. The programmers say, they use row locking within the transactions. Can I obtain informations about the users/processes that lock the table. With dblog / selog --> no chance. With ps -u : no chance. Other Ideas? Thanks for suggestions. Andy

"Dirk Moolman" <dirkm@reach.co.za> schrieb im Newsbeitrag news:91a6j8$rms$1@news.xmission.com... > > This works on Online 7 & 9 Hi Dirk, tks, but on-utilities are not available in SE 5.x. :-( Andy