Windows: 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.
About this task
You can optimize index and table reorganization for the server database. In this way, you can help to avoid unexpected database growth and performance issues. For instructions, see Technote http://www.ibm.com/support/docview.wss?uid=swg21683633.
If you update these server options while the server is running, you must stop and restart the server before the updated values take effect.