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