Re: error dropping database

On 27 Jan 1995, Edmund Wehling wrote: > > recently I get often the following error message: > > > Program stopped at "rmtext2db.4gl", line number 7. > > SQL statement error number -214. > > Cannot remove file for table (syscolumns). > > SYSTEM error number -106. > > ISAM error: non-exclusive access.> > after restarting informix the problem disappears. > Is this a bug in informix or is there probably something missing > in the environment or informix installation ? > > We have Informix Online 5.0 under AIX 3.2. > Sorry, I don't a answer/reply for this, I (my client actually, but it stills get back to me) am a victim too. I would like to know what are the possible causes, and what a DBA can do to prevent it from happening. In my case, it occurs after some (a few) DELETE operations. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Calvin Ng email: <calvinng@technet.sg> --------------------------------------------------------------------------- [DISCLAIMER] Read at your own risks. The author is not liable for any consequences directly or indirectly involved with reading this mail. This mail MAY NOT be interpreted as those of my employer's. --------------------------------------------------------------------------- This mail is sent with the help of Chameleon TCP/IP for Windows. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=