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