Re: Automating consistency checking
Posted in 1997
In article <5v4fu2$9u5@cssun.mathcs.emory.edu>, Rick Bernstein
<rbernste@alarismed.com> writes
>Informix recommends that the following commands be run
>periodically as part of a database consistency check:
> oncheck -cr
> oncheck -cc
> oncheck -ce
> oncheck -cI <dbname>
> oncheck -cD <dbname>>
>In trying to automate this process, I discovered that these
>commands may generate a non-zero return code when no problem was
>detected. How do other sites automate the verification that
>"consistency checking" commands did not encounter database problems?
>
>Your suggestions would be apprecicated.
>
>Rick Bernstein Phone: (619) 458-7048
>Alaris Medical Systems FAX: (619) 458-7640
>San Diego, CA 92121 Internet: rbernste@alarismed.com
>
Produce a log file which the Database Administrator musy check by
hand...
Normally a
grep -i error
helps..
--
David Williams