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

Check TABLE LOCK LEVEL! ------------------------------------------------------------------------- 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 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. } } Thank you in advance, } Kevin DeWitt } Pittsburgh, PA USA } }