Index maintenance

[Kenneth Brody]

On 12/19/2011 11:37 AM, Ian Wood wrote:
> I am having an issue almost daily where a file is getting bad automatic indexes.
>
> OS is:
> -----------------------------------------
> System information
> -----------------------------------------
> Windows 2008 R2
>     (Server Standard Edition (full installation))
> Mapi32 DLL build 1.0.2536.0 (win7_rtm.090713-1255)
>
> filePro version is 5.014DN9
>
> When looking at the index through dxmaint it says Invalid Index. I have to delete the index and then rebuild it manually.

The bigger problem is what's causing the indexes to become invalid.

> I need to be able to put this onto a menu to allow the user to do this as they are not in the same building as me.
>
> \fp\dxmaint -ra -e won't work as the index is invalid and when I go to build it, the field values are blank.
>
> I can't use the \fp\dxmaint -rf option as this is only for demand indexes as far as I can see in the documentation.
[...]

While it may have once been true that "-rf" was only for demand indexes, 
this is no longer the case.

But, as I said, the bigger issue is tracking down what's causing the indexes 
to become invalid.

-- 
Kenneth Brody