Migrating when the text search server is stopped

You can migrate to a new version of IBM® Text Search for Db2 for z/OS® while the existing installation of the text search server is stopped.

Procedure

To migrate when an existing text search server is stopped:

  1. Call the SYSPROC.SYSTS_STOP stored procedure to stop Db2 text search functions.
  2. Stop the existing text search servers by using the shutdown script.
    • On a Linux® or Linux on IBM Z® server, run the following script: <INSTALL_HOME>/bin/shutdown.sh
    • On a Windows server, run the following script: <INSTALL_HOME>/bin/shutdown.bat
  3. Install IBM Text Search for Db2 for z/OS over the existing installation of IBM Text Search for Db2 for z/OS.
  4. Restart the text search servers.
  5. For data sharing environments, 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_RESTORE
    • SYSPROC.SYSTS_STOP
    • SYSPROC.SYSTS_TAKEOVER
    • SYSPROC.SYSTS_UPDATE

    You must issue this command for all of these stored procedures. Optionally, you can complete this step for non-data sharing environments to ensure that another user does not interfere with the migration process.

  6. Refresh Db2 to ensure that the Db2 subsystem uses the new text search modules for future searches.
  7. 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 PI68310.
  8. Call the SYSPROC.SYSTS_START stored procedure to start Db2 text search functions.
  9. For data sharing environments, 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.

    Optionally, complete this step for non-data sharing environments if you stopped the stored procedures.