Re: Corrupt tables help needed

Though it may seem that Informix is the culprit, I would tend to think that your problem is with your hardware and not your software. I've never heard of a table continually being corrupted. I could be wrong but you may want to think about backing up your disk and reinitializing it to make sure you don't have any bad sectors that are causing your corruption problems. Nick Leporacci Ram'n Puchades <pandora@arrakis.es> wrote in article <612gcr$oes$1@talia.mad.ibernet.es>... > Hi. > > I've three old Informix installations that always death on the same touble: > table corruption. The Informix versions I'm using are Standard Engine 4.10 > and 5.01 over SCO UNIX 3.4.2. > > Always is the same: one day I discover, due to an error, that one table has > corrupted (usually because Informix cannot write something in log record > during an update). Then I repair table (usually by unloading, dropping, > re-creating and reloading all information in that table) and system > continues ok since it becomes corrupted again with no explanation. > > This is getting me crazy and makes me lost a lot of time copying and > reparing tables. And always get corrupted most important tables, those who > grew quicker or stores most variable info (hardest to backup always > updated). > > At least, I would like to understand the troube, even if I cannot solve it. > > Thanks a lot for your help > > Ram'n Puchades > System Analyst > R&D Departement > Cecom Data, S.A. > Valencia - Spain > > > >