Re: Req. solve for Lock error

dengelsen@my-dejanews.com wrote: > > Hello, > > How can I solve this error: > > 09:50:26 Process exited with return code 127: /bin/sh /bin/sh -c> /informix/ONLINE/etc/alarm.sh 3 21 "OnLine resource overflow: 'Locks'." "Lock > table overflow - user id > > Greetings, > > Ditmar den Engelsen Hi! Your options are: - Make your transaction shorter - Increase number of available locks (not very good one, since things tend to get slow with a transaction holding thousands of locks) - Change the locking level for affected table from row to page - Lock the whole table for duration of your transactions. Well, one doesn't know which option is worse, does one ? :) HTH Dragi "Bonzi" Raos