Verify DB2 Net Search Extender indexes using the NSE Index Verification tool

How to ensure that NSE text indexes are valid

From the developerWorks archives

Lalatendu Patro

Date archived: January 12, 2017 | Last updated: April 25, 2013|First published: August 16, 2012

Net Search Extender, here after called NSE, is an IBM® DB2® extender providing full text search support in DB2. NSE searches documents stored in columns of database tables by maintaining its internal text indexes. Rather than searching sequentially through text documents stored in database columns at query time, NSE uses its text indexes to search in an efficient manner. Verification of NSE indexes are vital because the errors reported by the top layer applications on full text index can be misleading. This unnecessarily delays the problem resolution at the production system. To prevent such a situation, the NSE Index Verification tool was developed to verify the NSE index validity and consistency, and to check whether or not indexes are valid.

This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some steps and illustrations may have changed.

Zone=Information Management
ArticleTitle=Verify DB2 Net Search Extender indexes using the NSE Index Verification tool