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:
- Populate the SYSIBMTS.SYSTEXTSERVERS table.
- Run a program that calls the SYSPROC.SYSTS_START stored procedure.
Example
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();