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

INET doesn't imply SE all this says is that they are accessing there DB in a location other then THERE PC could be an SE engine or ONLINE. INET is the Informix Netware Software used to get them to that DB. ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov DTSI, Inc. Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On Thu, 20 Jun 1996, John Prideaux wrote: } 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 } ------------------------------------------------------------------------------- }