Upgrading Db2 Text Search when applying Db2 fixpacks

To update a Db2® database product to the new fix pack level, apply fix pack update to the Db2 database product that is already installed.

Before you begin

Before you upgrade Db2 Text Search as administrator or root, complete the following steps:
  1. Log in as the instance owner or a user with SYSADM authority.
  2. Stop the Db2 database instance and the Db2 Text Search instance service.
  3. Back up the Db2 Text Search configuration directory:
    • For Linux® and UNIX operating systems, it is located under:
      $<INSTHOME>/sqllib/db2tss/config
      where <INSTHOME> is the instance home directory.
    • For Windows systems, it is located under:
      <INSTPROF>\<INSTNAME>\db2tss\config
      where <INSTPROF> represents the instance profile directory and <INSTNAME> indicates the name of the instance to be upgraded.
  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, refer to Disabling support for rich text and proprietary formats.
    Run the richtextTool utility from the Db2 command window to disable support.
    • For Linux and UNIX operating systems, run the following command:
      $<INSTHOME>/sqllib/db2tss/bin/richtextTool disable DB2-install-directory
      where <INSTHOME> is the instance home directory.
    • For Windows operating systems, run the following command:
      <DB2PATH>\db2tss\bin\richtextTool.bat disable DB2-install-directory
      where <DB2PATH> is the location where you installed your Db2 database server copy

About this task

Steps necessary for upgrading Db2 Text Search when applying Db2 fix packs.

Procedure

  1. Upgrade the Db2 Text Search server for your Db2 instances by issuing the configTool upgradeConfigFolder command. This command must be run as instance owner, and not root.
    • For Linux and UNIX operating systems, run:
      $<DB2DIR>/db2tss/bin/configTool upgradeConfigFolder 
      -sourceConfigFolder $<DB2DIR>/cfg/db2tss/config
      -targetConfigFolder $<INSTHOME>/sqllib/db2tss/config
      where, <INSTHOME> is the instance home directory and <DB2DIR> is the location of the newly installed copy.
    • For Windows operating systems, run:
      <DB2PATH>\db2tss\bin\configTool upgradeConfigFolder 
      -sourceConfigFolder "<DB2PATH>\CFG\DB2TSS\CONFIG"
      -targetConfigFolder "<INSTPROFDIR>\<INSTANCENAME>\DB2TSS\CONFIG"
      where, <DB2PATH> is the location of the newly installed copy and <INSTPROFDIR> is the instance profile directory.

    The configTool upgradeConfigFolder command replaces, modifies, and merges text search configuration and data files and directories.

    The config directory

    The command copies the following files into the <ECMTS_HOME>\config directory if the files do not already exist in this directory:
    • constructors.xml
    • ecmts_logging.properties
    • ecmts_config_logging.properties
    The following files are copied and any existing files are overwritten:
    • build_info.properties
    • constructors.xsd
    • ecmts_config_logging.properties
    • mimetypes.xml
    • monitoredEventsConfig.xml
    The configuration settings from the following files are merged to the configuration.xml file. Values are added for new settings, and values are maintained for existing settings.
    • config.xml
    • jetty.xml
    The following files are not modified:
    • authentication.xml
    • key.txt
    • All files in the collections subdirectory

    The log directory

    The command does not change the contents of the existing log directory. However, when new log files are generated, those new files might replace existing log files.

    The configTool upgradeConfigFolder command does not upgrade text search filters for an integrated text search server.

  2. Review the values for all Db2 Text Search configurable properties. Issue the following command to check the configuration values:
    configTool printAll -configPath <configuration-directory>
  3. If you disabled Db2 Text Search for rich text document support and want to enable it again, continue with step 3. If you do not want to enable rich text document support, skip to step 4.

    Stop Db2 Text Search and then install the corresponding version of Rich Text Filter (RTF) associated with your particular Db2 version.

    For information on installing RTF, refer to Installing Db2 Accessories Suite for Db2 Text Search.

    For information on enabling RTF, refer to Enabling Db2 Text Search for rich text document support.

    For more information, refer to Installing Db2 Accessories Suite for Db2 Text Search.

  4. 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 or not by issuing text search queries and compare with pre-upgrade results.