Detecting corrupt or invalid indexes ahead of time

Walter Vaughan wvaughan at steelerubber.com
Wed Nov 5 10:19:23 PST 2008


Mike Schwartz wrote:

> Does anybody have a utility that detects a corrupt or invalid index 
> before a user encounters it? If filePro can tell me that I have an 
> “invalid” index when I rebuild it, then can I programmatically examine 
> all the indexes on a continuous basis in order to determine exactly 
> when an index went “invalid”?
>
> One of my customers is running a large filePro 5.0.5D4 system on SCO 
> Openserver 5.0.6. Lately they have been having an occasional problem 
> with one or more of the indexes getting corrupted.
>

Well, I would posit that getting corrupted indexes cannot happen unless 
you cause them.
You are running on an unsupported OS with known issues, and a version of 
filepro with known issues,
on probably horribly out of date hardware that may be suffering from 
heat or age related issues.

Who knows what you or someone else has done with disk buffers to mess 
things up in order to
work with your large installation.

--
Walter


More information about the Filepro-list mailing list