Configuring server options for server database maintenance

To help avoid problems with database growth and server performance, the server automatically monitors its database tables and reorganizes them when needed. Before starting the server for production use, set server options to control when reorganization runs. If you plan to use data deduplication, ensure that the option to run index reorganization is enabled.

1. Modify the server options.

   Edit the server options file, dsmserv.opt, in the server instance directory. Follow these guidelines when you edit the server options file:

   • To activate an option, remove the asterisk at the beginning of the line.
   • Create an option on any line.
   • Enter only one option per line. The entire option with its value must be on one line.
   • If you have multiple entries for an option in the file, the server uses the last entry.
   • To view available server options, see the sample file, dsmserv.opt.smp, in the /opt/tivoli/tsm/server/bin directory.
   Edit the server options file, dsmserv.opt, in the server instance directory by using a text editor. Follow these guidelines when you edit the server options file:

   • To activate an option, remove the asterisk at the beginning of the line.
   • Create an option on any line.
   • Enter only one option per line. The entire option with its value must be on one line.
   • If you have multiple entries for an option in the file, the server uses the last entry.
   • To view available server options, see the sample file, dsmserv.opt.smp, in the c:\Program Files\Tivoli\TSM directory.
2. If you plan to use data deduplication, enable the ALLOWREORGINDEX server option. Add the following option and value to the server options file:

   allowreorgindex yes

3. Set the REORGBEGINTIME and REORGDURATION server options to control when reorganization starts and how long it runs. Select a time and duration so that reorganization runs when you expect that the server is least busy. These server options control both table and index reorganization processes.
   1. Set the time for reorganization to start by using the REORGBEGINTIME server option. Specify the time by using the 24-hour system. For example, to set the start time for reorganization as 8:30 p.m., specify the following option and value in the server options file:

      reorgbegintime 20:30

   2. Set the interval during which the server can start reorganization. For example, to specify that the server can start reorganization for four hours after the time set by the REORGBEGINTIME server option, specify the following option and value in the server options file:

      reorgduration 4

4. If the server was running while you updated the server options file, stop and restart the server.