Db2 Text Search server configuration

You can tune your Db2 Text Search configuration by adjusting the queue sizes, heap size, number of indexing threads, and other factors. Balance your adjustments to these different parameters for optimal performance of your system.

For the Db2 Text Search server configuration the number of indexer threads should not exceed the number of CPUs, and the number of parallel updates should not exceed the number of indexer threads. Note that to determine the number of parallel updates in a partitioned database the number of indexes is multiplied with the number of collections for a text index.

Stop the Db2 Text Search instance services using the db2ts STOP FOR TEXT command before making any configuration changes.

Start the configUtility.

For an integrated text search server it is located in the <TS_HOME>/bin directory.
For an stand-alone text search server it is located in the <ECMTS_HOME>/bin directory.

For example, to change the number of indexing threads:

configTool configureParams -configPath configPath -numberOfIndexingThreads 3

For your changes to take effect, restart the Db2 Text Search processes.