Post-migration tasks - enabling text search feature on DB2 database

About this task

To enable the Text Search feature on a DB2® Database, perform these tasks:

Procedure

  1. Ensure that the DB2 database is configured with the IBM® DB2 Net Search Extender plug-in.
  2. Log in to the DB2 server using the command editor or command-line processor with a user ID having DBA privileges.
  3. If upgrading in nonsharded mode, run the create.sql script and the update.sql script from the <INSTALL_DIR>/Migration/9.4/database/scripts/db2/textsearch directory.

    -or-

    If upgrading in sharded mode, run the create.sql script and the update.sql script from the following directories for each colony:

    • <INSTALL_DIR>/Migration/9.4/database/scripts/db2/textsearch/TRANSACTION
    • <INSTALL_DIR>/Migration/9.4/database/scripts/db2/textsearch/MASTER
    • <INSTALL_DIR>/Migration/9.4/database/scripts/db2/textsearch/CONFIGURATION
    • <INSTALL_DIR>/Migration/9.4/database/scripts/db2/textsearch/STATISTICS

      The create.sql script creates text search indices (if it contains any scripts) and the update.sql script updates the existing text search indices (if it contains any scripts).

      Note: Perform 4 only if the text search index creation is successful.
  4. Use the <INSTALL_DIR>/properties/customer_overrides.properties file to set the following property:

    yfs.db.textsearch to Y

    Note: To drop the text search indices from the DB2 database, run the drop.sql script.