Upgrading Db2 Text Search for non-root installation (Linux and UNIX)

If you are upgrading Db2® Text Search version 11.5, you must upgrade the Db2 server, instance, and all databases.

Before you begin

Complete the following tasks before you begin to upgrade your text search server:
  1. Enable the root-based features for your user ID. You might have to ask a system administrator with root access to issue the db2rfe command.
  2. Log in as the instance owner or as a user with SYSADM authority. Then stop the Db2 instance and the Db2 Text Search instance service.
  3. Back up the old Db2 copy into a <backup-dir> directory.
  4. If you enabled Db2 Text Search for rich text document support, disable rich text document support. For more information about how to disable rich text document support, see disabling Db2 Text Search for rich text document support.
  5. Log on to the Db2 server as a non-root user. Review the database instance type to ensure it can be upgraded as a non-root installation.


To upgrade Db2 Text Search:

  1. Install a new Db2 version 11.5 copy with the db2nrupgrade upgrade command. Select the Db2 Text Search component that you want to upgrade. If you specified the -f nobackup parameter and the Db2 database product installation failed, you must manually install the Db2 database product by selecting the Db2 Text search component from the feature tree and then upgrade the non-root instance by issuing the following command:
    db2nrupgrade -b <backup-dir> -j "TEXT_SEARCH"
    <backup-dir> specifies the directory where the configuration files from the old Db2 version are stored. For details about the upgrade non-root instance command, see db2nrupgrade command.
  2. Back up values for all configurable properties of Db2 Text Search that is used in the previous release before the database upgrade by running the following script:
    The backed-up configurable properties are redirected into the $INSTHOME/sqllib/db2tss/config/db2tssrvupg.cfg property file.
  3. Upgrade the existing databases by issuing the UPGRADE DATABASE command.
  4. For each upgraded database, verify whether the text search properties information in the text search catalog table SYSIBMTS.SYSTSSERVERS is correct by comparing the information with the property values from step 6. If the value of token or port number in the catalog table is empty or incorrect, you must update the text server information manually.
    For more information about the upgrading non-root instance, see updating Db2 Text Search server information.
  5. Upgrade the Db2 Text Search server for your instances by issuing the configTool upgradeInstance command.
    • For Linux® and UNIX operating systems:
           $DB2DIR/db2tss/bin/configTool upgradeConfigFolder  
               -sourceConfigFolder $DB2DIR/cfg/db2tss/config
               -targetConfigFolder $INSTHOME/sqllib/db2tss/config
      INSTHOME is the instance home directory and DB2DIR is the location of the newly installed 11.5 copy.
  6. Compare the values that you backed up in step 6 with the values for all the Db2 Text search configurable properties to ensure that all the values are correct.
    Issue the following command to check the configuration values:
    configTool printAll -configPath configuration-directory
  7. If you disabled Db2 Text Search for rich text document support, you must install the Db2 Accessories Suite.
    For information about the Accessories Suite, see installing Db2 Accessories Suite for Db2 Text Search.
  8. Then enable rich text document support.
    For more information about enabling support, see enabling Db2 Text Search for rich text and proprietary format support.
  9. Verify that the upgrade was successful by starting the Db2 Text Search instance service. If you disabled rich text document support, verify that rich text document support is enabled by issuing text search queries and compare with pre-upgrade results.