>I have a process that has worked fine for over
>a year. Today the system is locking up and I'm
>not sure why.
>
>I suspect that it may be the result of a corrupted
>index tag. Is there a way to tell if an index tag is
>indeed corrupted? Is there a rule of thumb as
>to how often the rebuild should take place?
>I've also heard that I should not simply do a
>REINDEX but that it should be a DELETE TAGS ALL
>and then create the indexes. Is there an automated
>way to do this?


I would reindex whenever possible - on a set schedule. The way to recreate indexes is to...
SELECT YourDataBase EXCL
DELETE TAG ALL
PACK
INDEX ON tagname TAG tagname ADDITIVE
INDEX ON tagname2 TAG tagname2 ADDITIVE
INDEX ON tagname3 TAG tagname3 ADDITIVE
USE

HTH
Wayne