Database Optimization on Linux and UNIX Systems

The installation program prompts you to set up database optimization daily. If you select to optimize the database daily, the installation script adds the following command to the cronjob file. You can add this command to the cronjob file at any time to begin daily optimization of the database.

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

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