How to Disable Automatic Database Optimization

If you uninstall a Red Hat Linux Master Server, you must manually remove the entry from the crontab file that instructs the system to automatically optimize the database. The uninstall script for Solaris Master Servers automatically removes this entry from the cronjob file.

Steps

1. As the user that owns the Master Server, list the current crontab and direct the output to a file.

   # crontab -l > newcrontabfile

2. Open the newcrontab file in a text editor.

3. Remove the following line from the newcrontab file.

   MM HH * * * N1SPS5.0-home/server/bin/roxdbcmd vacuumdb -d rox > /dev/null 2> /dev/null

   N1SPS5.0-home is the home directory of the Master Server.

4. Save the newcrontab file.

5. Update the crontab.

   # crontab newcrontabfile