Adding a text search server to the system

After initially populating the SYSIBMTS.SYSTEXTSERVERS table, the Db2 database administrator can add another text search server by updating the connectivity information in the administration table.

Procedure

To update the text search server connectivity information:

  1. Populate the SYSIBMTS.SYSTEXTSERVERS table.
  2. Run a program that calls the SYSPROC.SYSTS_START stored procedure.

Example

The following two sample SQL statements show how to add a new text search server to the Db2 subsystem:
INSERT INTO SYSIBMTS.SYSTEXTSERVERS(SERVERNAME,SERVERPORT,SERVERAUTHTOKEN, 
SERVERMASTERKEY, DB2ENCRYPTEDPW) 
VALUES('9.30.176.75',10000,'1aPgk6Q=','1aPgk6TkD/FVt8BuCyO8Bg==', 
SYSFUN.SYSTS_ENCRYPT('db2 password value', '1aPgk6TkD/FVt8BuCyO8Bg=='));
CALL SYSPROC.SYSTS_START();