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

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? Impossible to say with the information you have provided. > 2) What program does Informix use to correct the situation? It is a custom program written by the folks in support to patch various things on disk within an OnLine system. > 3) Can I obtain a copy of this program (or something similar)? Absolutely not. Without detailed knowledge of the many data structures existing in an OnLine system, you would not be able to do anything useful with it (and could well make things much worse). Only the advanced tech support people use these patch utilities, and even they do so with a great deal of caution. Dave -- Disclaimer: These opinions are not those of Informix Software, Inc. ************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney