Migrating when the text search server is running
You can migrate to a new version of IBM® Text Search for Db2® for z/OS® while an existing installation of IBM Text Search for Db2 for z/OS is still running.
Procedure
To migrate when an existing text search server is running:
-
Prevent Db2 from accepting SQL CALL
statements from the text search stored procedures by issuing the following command from a Db2 subsystem console:
STOP PROCEDURE (<proc>) ACTION(REJECT) SCOPE(GROUP)where <proc> is one of the following stored procedures:
- SYSPROC.SYSTS_ALTER
- SYSPROC.SYSTS_CREATE
- SYSPROC.SYSTS_DROP
- SYSPROC.SYSTS_STOP
- SYSPROC.SYSTS_TAKEOVER
- SYSPROC.SYSTS_UPDATE
You must issue this command for all of these stored procedures.
- Rebind the stored procedures. Note: You can skip this step if you already performed it when completing the ++HOLD actions for the PTF for APAR PM55239 and APAR PM84540. Otherwise, before migrating from DB2® 10 to Db2 11, apply APAR PM55239 and APAR PM84540 and follow the ++HOLD instructions.
- Identify the IBM text search servers that you have installed by referring to the SYSIBMTS.SYSTEXTSERVERS administration table. For each text search server that is installed, complete the following steps:
- Install the new IBM Text Search for Db2 for z/OS in a new installation directory by using a different response file for each text search server.
- Start the new text search servers by using the startup
script that is provided.
- On a Linux or zLinux server,
run the following script:
USER_INSTALL_DIR/bin/startup.sh - On a Windows server,
run the following script:
USER_INSTALL_DIR/bin/startup.bat
- On a Linux or zLinux server,
run the following script:
- For each text search server, add the server name (SERVERNAME), port (SERVERPORT), authentication token (SERVERAUTHTOKEN), and master key (SERVERMASTERKEY) to the SYSIBMTS.SYSTEXTSERVERS administration table.
- Update the encrypted password value for the DB2ENCRYPTEDPW
column of the SYSIBMTS.SYSTEXTSERVERS administration table by issuing
the following command:
where <myDB2UIDpw> is the password that you specify.UPDATE SYSIBMTS.SYSTEXTSERVERS SET DB2ENCRYPTEDPW = SYSFUN.SYSTS_ENCRYPT (<myDB2UIDpw>,SERVERMASTERKEY); - In the SYSIBMTS.SYSTEXTSERVERS administration table, make note of the server ID for each of the new text search servers.
- Call the SYSPROC.SYSTS_START stored procedure to start text search functions.
- Restore the text search indexes to the new text search
server by calling the SYSPROC.SYSTS_RESTORE stored procedure.
You can find the information about all of the text search indexes in the SYSIBMTS.SYSTEXTINDEXES administration table. Restore the text search indexes to the new IBM Text Search for Db2 for z/OS server by issuing the following command:
CALL SYSTS_RESTORE (<indexSchema>,<indexName>,<serverID>) - After all of the text search indexes are restored to the new IBM Text Search for Db2 for z/OS servers, remove the old server entries from the SYSIBMTS.SYSTEXTSERVERS administration table.
- Reactivate the definitions of the stored procedures that
were stopped by issuing the following command:
START PROCEDURE (<proc>) SCOPE(GROUP)where <proc> is the name of the stored procedure.