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();