Re: sysviews corrupted

Art S. Kagel wrote: > > Guy Germonpre wrote: > > > > Hi, > > > > I have an Informix Online 4.10.UD2 on SCO 3.2v2.1. this thing worked for > > a LONG time, but now i get errors "ptalloc bad page ..", and my sysviews > > table is gone. > > I unloaded all data, did a tbinit -i, and reloaded everything. > > 2 days later the same problem. > > I switched the disk. > > 5 days later the same problem. > > > > This can't be bad luck. What is going wrong ? > > Do you use cooked files? Do you shut down the Informix Engine before > shutting down or rebooting the machines either manually or through RC > scripts? Have you had a crash that caused the machine to go down > without executing normal shutdown? These are all possible causes of > corruption. Others include a controller or power supply that is going > bad and has become flaky. > > Art S. Kagel No we (my customer) does not use cooked files, the engine nor the machine itself was not shut down prior to the error, no crash, just suddenly a corrupted engine 3 or 4 times in a row. The customer told me he had the error while creating temporary tables via sequelink. There is anough disk space and database space so it is not caused by shortage of disk. Do you really think it can be caused by HARDWARE ? Guy