Upgrading to Db2 Net Search Extender

Before upgrading Net Search Extender to Db2 Net Search Extender, you must have successfully upgraded your Db2 server and instance (on Linux® and UNIX) including all databases to Db2 version 11.1

Before you begin

Important: Net Search Extender has been deprecated. Its use is no longer recommended and might be removed in a future release. Use Db2 Text Search as a fast and versatile method of searching full-text documents stored in Db2 databases using SQL and XQuery statements. See the topic about Migration overview from Net Search Extender to Db2 Text Search for details.

Back up all text index directories and index subdirectories before upgrading. Refer to Backing up and restoring text indexes.

About this task

Upgrade to Net Search Extender is supported from Net Search Extender Version 9. 5 or Version 9.7.

Procedure

To upgrade to Db2 Net Search Extender:

Upgrade your Db2 server where Net Search Extender is installed using any of the following tasks:
Upgrading your database is part of these tasks. If you have external unfenced routines on Linux or UNIX that have no dependency on the Db2 engine libraries, the UPGRADE DATABASE command redefines your external routines as FENCED and NOT THREADSAFE. See Upgrading C, C++, and COBOL routines for details on how to safely run your routines in the new multithreaded database manager. The Net Search Extender functions with schema name DB2EXT that were altered during the database upgrade are redefined as NOT FENCED and THREADSAFE by the db2extmdb script in step 5.
Install Db2 Net Search Extender .
Unlike Db2 database, Db2 Net Search Extender does not support an 'upgrade installation'.

If your installed Db2 copy was moved to by using the Db2 'upgrade installation' option, the installed Db2 Net Search Extender copy is still at the previous version level.

If you try to install Db2 Net Search Extender on top of an earlier version of Db2 Net Search Extender, you receive an error message that the existing Db2 Net Search Extender installation has to be removed first. In this case, uninstall the earlier version of Db2 Net Search Extender before installing Db2 Net Search Extender . On Windows operating systems, reboot the machine after uninstallingDb2 Net Search Extender.
A Db2 Net Search Extender instance upgrade is only applicable on Linux and UNIX. This step has to be ignored on Windows operating systems. To upgrade the instance, log on as root and run the db2extimigr script using the following syntax:
```
DB2DIR/instance/db2extimigr [-h|-?] InstanceName
```
Where DB2DIR is the directory where you installed your Db2 version 11.1 copy.
On Linux and UNIX, after a successful Db2 Net Search Extender instance upgrade, verify the installation before you continue with the database upgrade. On Windows operating systems, you can verify the installation immediately.
Note: Do not apply the Db2 Net Search Extender sample scripts to a database that is not upgraded to Db2 Net Search Extender . A secure way is to create a database to carry out the verification. See Installation verification on UNIX and Installation verification on Windows for more details.
Upgrade every database that had been enabled for Net Search Extender in a pre- release. Step a) and c) are currently needed to resolve a known problem with db2extmdb (duplicate entries in the view DB2EXT.DBDEFAULTS after database upgrade). To perform the database upgrade steps:
1. Log on to the Db2 server as the instance owner.
  
  You must be able to successfully stop or start the Net Search Extender instance services, you need DBADM with DATAACCESS authority on the database to be upgraded. On Windows operating systems, the instance user must be part of the Local Administrator group.
  
  On Windows operating systems, you need to proceed from a Db2 command window that is running with full administrative privileges. See User Access Control feature for more details.
  
  On the Windows 2008 and Windows Vista operating system (and later), the db2extmdb command does not work if it is started from a command window running with standard user rights. ("CTE0228 The user has insufficient access rights at the operating system level").
2. Run the db2extmdb script to upgrade the database that you enabled for Net Search Extender using the following syntax:
```
db2extmdb database-name
```
  While you are running this script, avoid changing user tables with text indexes. You can repeat the command for every database that has Net Search Extender indexes.
  All upgrade steps are logged in the file called db2extmdatabase-name.log located in one of the following directories:
  - INSTHOME/sqllib/db2ext/ on Linux and UNIX operating systems
  - DB2PATH\db2ext\ on Windows operating systems
  Where INSTHOME is the instance home directory and DB2PATH is the location where you installed your Db2 version 11.1 copy.
If you upgraded from pre-version 11.1 Db2 32-bit server to a version 11.1 64-bit server, the indexes that were created need to be migrated to 64-bit.
To migrate indexes, refer to one of the following topics:
- DB2 Net Search Extender index migration tool from 32-bit to 64-bit (Windows), for Windows operating systems.
- DB2 Net Search Extender index migration tool from 32-bit to 64-bit (Linux/Unix), for Linux and UNIX operating systems.
In Db2 Net Search Extender for UNIX and Linux operating systems, the text indexes that you created in a 32-bit instance cannot be used in a 64-bit instance. The text indexes can be used only when the migration tool is used to modify the indexes, otherwise the search engine returns error CTE0101 Reason code: "17" when the indexes are not migrated. If you choose not to use the migration tool, you can drop the text indexes and re-create them.