Administration

Net Search Extender requires similar administration as Text Extender. Common administrative tasks include updating and reorganizing an index, changing index settings, and managing index events. Updating an index incrementally updates an index with current database information. Reorganizing an index reorders the entire index so it runs more efficiently. Index settings such as automatic updating, can be configured at any time. Index events are used to report problems that need to be corrected. Net Search Extender allows REORGANIZE to be specified as an option in the UPDATE INDEX command. Here is the basic syntax:

db2text UPDATE INDEX index-name FOR TEXT [REORGANIZE] [CONNECT TO database-name]

When a problem is detected, an error event record is written to the index event view. The events can be checked by performing a SELECT on this view. The event view name can be found in the EVENTVIEWNAME column of the DB2EXT.TEXTINDEXES view. Here is the syntax for clearing the index event view.

db2tx CLEAR EVENTS FOR INDEX index-name FOR TEXT [CONNECT TO database-name]