Net Search Extender
Net
Search Extender offers users and application
programmers a way to search full-text documents that are stored in Db2® databases, other
databases, and file systems with the use of SQL queries.
Configuring Net Search Extender (NSE) for high availability (HA)
Db2 Net Search Extender can be configured to support high availability by sharing the indexes between the high availability nodes, as well as Net Search Extender index backup and restore operations. Net Search Extender full-text indexes consist of data stored in a Db2 database, and in some external files located on the file system. Only Net Search Extender data within the database are recovered during failover by configuring Db2 for high availability. The NSE specific external files need to be shared with the fail-over node, using a file sharing technology applicable to the user scenario and the platform in use. The external files are not restored if any index update operation are interrupted, causing the index files to get corrupted. The files need to be backed-up to restore them manually.
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
Migrating to DB2 Text Search
Db2 Net Search Extender index migration tool from 32-bit to 64-bit (Linux/Unix)
Net Search Extender indexes built under 32-bit Db2 instances are not compatible with 64-bit instances. To avoid the need to completely rebuild your indexes, you can use a tool to migrate the indexes offline. The current version of tool supports only AIX® and Solaris operating systems.
Db2 Net Search Extender index migration tool from 32-bit to 64-bit (Windows)
Db2 Net Search Extender indexes built under 32-bit Db2 instances are not compatible with 64-bit instances. Trying to search or to update an index that was built under a 32-bit Db2 instance in a 64-bit instance results in an error message being returned.
Planning considerations
Planning before using features is a good practice to ensure you're getting the most out of the database functionality.
Developing: creating and maintaining a text index
There are certain areas of text index creation and maintenance which are important to review before proceeding.
Maintaining text indexes
A number of maintenance tasks must be performed to maintain text indexes and obtain useful information about their status.
Methods for searching text
The Net Search Extender allows SQL scalar search functions, a stored procedure search function, and an SQL table-valued function to search text.
Working with structured documents
Net Search Extender allows you to index and search text or numeric fields, such as title, author, or price in a structured document.
CTEU0SYM.IDE
The following topic contains common conrefs for Net Search Extender topics.