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.
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.
- 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:
-
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").
- 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:
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.