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

If running INET, doesn't that imply SE, not ONLINE? In that case, the problem is probably adjacent key locking and length of transaction. If ONLINE, the table lock level is probably the culprit, as Cheryl and others have mentioned. Cheryl Kendricks wrote: > > Check TABLE LOCK LEVEL! > > On 18 Jun 1996, 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. > } -- ------------------------------------------------------------------------------- John Prideaux e-mail: alastl@ix.netcom.com Phone: (217)839-2121 Aladdin Steel, Inc. Fax: (217)839-4327 -------------------------------------------------------------------------------