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 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) 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 Developing: creating and maintaining a text index Maintaining text indexes Methods for searching text 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