corrupted Index

[WILLIAM LUCCA]

I have a processing table that rebuilds all automatic indexes that I run either every night or once a week on a few of my clients' systems.  It does not solve the problem like fixing the code would, but it may help while you are trying to track down the root cause and is still not a bad idea to run weekly even when you do.  I'd could send you the processing table I wrote if you are interested.
Bill Lucca
 

    On Tuesday, January 10, 2017 1:10 PM, Kenneth Brody via Filepro-list <filepro-list at lists.celestial.com> wrote:
 

 On 1/10/2017 12:15 PM, Linda Gray via Filepro-list wrote:
> Hi all,
>
> We have an index.A for a sometimes large file.  We run a lot of reports from
> this file using the index.  The index is constantly getting corrupted.  Does
> anyone know of a way to prevent this?

In what way is it getting "corrupted"?

I might suggest the first think to do is set PFCHECKLOCK=ON and 
PFCHECKLOCKLOG=/path/to/a/logfile.  See if there are any unprotected lookups 
that are being modified.

(Also, what is a "sometimes large file"?)

-- 
Kenneth Brody
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes
http://mailman.celestial.com/mailman/listinfo/filepro-list


   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20170110/ed41d0d7/attachment.html>