Re: -113 ISAM error: - the file is locked

dewitt@interramp.com (Kevin DeWitt) wrote: >I receive this message when two users do an INSERT at very nearly the same >time. The table being updated has one key column defined as SERIAL. We were >experiencing this problem prior to making the key SERIAL. >Does anyone have any suggestions? We are running Informix 7.x under INET 5.1 >on a Sun server. I don't believe our database environment uses files for >locking. You make want to check your locking mode on the table. If this is a highly volatile table(lots of updates), you probably want to set the lock mode to row level locking. The default is page level locking. this would help keep your users from bumping into each other on updates. If the table is currently using row level locking, the other thing to do is in the application, use the 'set lock mode to wait xx' where xx is some number of seconds where a process will wait for a lock to be released. The default is 'not wait' which means if the process can not obtain a lock immediately, an error code such as 113 is return. Hope this helps. -- Melvin Mariney, Informix DBA e-mail: melvin.mariney2@bridge.bellsouth.com