Configuring multiple Db2 Text Search servers

Db2 Text Search can be configured on multiple stand-alone servers, which provides the flexibility to setup and distribute indexes across servers.

Before you begin

Before you can configure multiple stand-alone Text Search servers, you must install each server that you intend to add to the setup. For more information, see Installing a stand-alone DB2 Text Search server.

Before configuring the properties, ensure that each stand-alone Db2 Text Search server is shut down and that the text search services are stopped.

You can use the configuration tool to view text search server properties even when the text search server is stopped.

About this task

Make sure to review and configure at minimum the following properties with the configuration tool:
  • configureHTTPListener: Configures the Db2 Text Search server port and host name
  • generateToken: Generates the authentication token and encryption key
  • defaultDataDirectory: Configures the parameters for the collection

Procedure

To configure a stand-alone Text Search server that you intend to add to the multiple server setup, follow these steps:

  1. Configure the Db2 Text Search server port and host name by entering the following command:configTool configureHTTPListener -adminHTTPPort port-number -configPath absolute-path-to-config-folder
  2. Explicitly provide the seed value and generate the authentication token by running the following command: configTool generateToken -seed value -configPath absolute-path-to-config-folder
  3. Start the standalone text server.
  4. Obtain the configuration values by entering the following command: configTool printAll -configPath configuration-directory
  5. Review the entries in the SYSIBMTS.TSSERVERS administrative view and make any necessary updates:
    • If the view is empty then use an INSERT statement. For example:
      INSERT INTO SYSIBMTS.TSSERVERS (HOST,PORT,TOKEN,KEY,LOCALE,SERVERTYPE,SERVERSTATUS) 
      values ('host-name', port-number, 'token-value', 'key-value', server-type, serverstatus-type);
    • If the view already contains a row then use a UPDATE statement. For example:
      UPDATE SYSIBMTS.TSSERVERS SET (HOST, PORT, TOKEN) 
      = ('host-name', port-number, 'token-value');
  6. Execute the SYSTS_CONFIGURE procedure. For more details, see the topic about the SYSTS_CONFIGURE procedure.
  7. Verify the values in the SYSIBMTS.TSSERVERS administrative view are those returned by configuration tool.
  8. Start the text search service to verify that the text search server can be contacted.
  9. Do each of the above steps for each server that you intend to add to the multiple server setup.

Results

Note: The maximum number of servers that can be configured is 99.