Re: Msg: Cannot remove file for table().

In article <1993Jan21.153628.22858@walter.bellcore.com> pak2@base.bellcore.com (Paul Kupersmith) writes: >Using Informix 4.1, when I try to drop a database, I get the following >message: > > 214: Cannot remove file for table ().> >I have called Informix support, and they have stated that the dbspace >has been corrupted. Their proposed work around to me is to reinitialize >the dbspace. This is unacceptable to me due to the downtime it would >cause to the production systems dependent upon that dbspace. > >BTW, If the database contained "production" data, Informix extended an >offer to dial into the system and correct the problem. > > >I have two questions: > > 1) What is causing the dbspace to be corrupted? > 2) What program does Informix use to correct the situation? > 3) Can I obtain a copy of this program (or something similar)? > >Thank you, > >Paul Paul, we had a similar problem creep up on us using Informix 4.1 on a Motorola 88Open machine. We had lost a table and Informix told me that this was caused by a "nasty and known bug" (Sorry, can't remember the BUG #). The only solution to our problem was to remove the table from systables and then try to recreate the table. Informix sent us another port of the Online engine to fix the problem. The corruption was caused (so they say) by a series of update statements within the code. This code had been running just fine for over one year. Now that we have this new port, the problem has gone away and we were able to recreate the table (thank god it only had 13 rows...). Hope this helps, Matt... (Do not reply to the above E-Mail address, it belongs to a friend of mine)