checkdb

The checkdb and checkalloc scripts check the internal integrity of the Sybase database, and should be run regularly when Alto is not in use. The scripts should be scheduled using the cron as the user ops.

Usage

Example cron tab lines for automating "checkdb" and "checkalloc" are shown below:

30 0 * * 0 /bin/su - ops -c "checkdb /var/tmp/checkdb.run" 2/var/tmp/checkdb.err
5 * * 0 /bin/su - ops -c "checkalloc  /var/tmp/checkalloc.run" 2/var/tmp/checkalloc

The first line executes checkdb at 12:30AM on Sunday mornings.

The second line executes checkalloc at 5:00AM on Sunday mornings.

Notes

• On older systems these scripts can take many hours to run. Sybase 12 offers an alternate script called checkstorage which is faster and more efficient.

• The checkdb and checkalloc outputs must be checked after each run. Use the grep command to search for Sybase error messages. For example:
  grep Msg /var/tmp/checkalloc.log

• Report any error messages to Capita Support.