Re: Corrupt tables help needed

In version 5.0x, one very common way for tables to become corrupt, was for the the back end SQLTURBO process to die badly (kill -9, etc). After a few of these, the chances of corruption go way up. Another possible cause is a marginal hardware fault. Have your hardware vendor to a full, low-level diagnostic on the box. -d At 12:08 PM 10/3/97 +0100, Ramon Puchades wrote: } 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=F3n Puchades }System Analyst }R&D Departement }Cecom Data, S.A. }Valencia - Spain } } } } }