Re: sysviews corrupted

BALLENTINE.MIKE@heb.com wrote: > copy /dev/zero over the offending chunk and then reinitialized, > did the problem go away. However, if you replaced the disk(s) > that the database uses, this is probably not the problem. > > Barring that, I would agree that it sounds like a hardware > problem. > Art S. Kagel wrote: > > > > Guy Germonpre wrote: > > > > > 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. > 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 ? Sounds like it. Especially power supply. Have you recently added some additional hardware? The power supply when it is going or is over stressed will introduce spikes in the power and can corrupt data being read or written by the controllers. I had this. There may not even be any physical damage just flaky reads. If you have added hardware, additional disks, a new CDROM, internal modem, etc. about the time that the problem showed up I'd say that you need a more powerful power supply otherwise try replacing that first anyway as the cheapest possible culprit. If you've got a hardware tech available you can have everything checked out. Art S. Kagel