database consistency checks & repairs?

[heindhoven]

Last week we had a corrupt index on a progress (9.1e) database.
After reindex, the problem was solved.
My question is:
What is the best way to regulary check the db consistency so we can prevent this type of problems? Are there any "standard" scripts/batch files out there with the 'standard' db checks & repairs?
Thanks in advance!

 

[RealHeavyDude]

One thing that springs to my mind is the index check. The utility is smart enough to recognize whether the database is on- or offline and uses the corresponding mode.

Something like

proutil dbname -C idxcheck all > idxcheck.log

should do for you.

However, I recommend you to read the documentation about these utilities before you use it to fully understand what they're doing.

HTH, RealHeavyDude.