Administration

To keep the Text Extender index information current, some administrative tasks are required. Common administrative tasks include updating and reorganizing an index, changing index settings, and managing index events. Updating an index incrementally adds changes to an existing index with current database information. Reorganizing an index reorders the entire index so it runs more efficiently. Index settings, such as automatic updating frequency, can be changed at any time. Index events are used to report problems that need to be corrected.

Updating an index refreshes the index information with recent changes to the corresponding documents in the database. There are two ways to keep the index information up to date. The first method is to manually run an update using the UPDATE command. The second method is to configure the index to automatically update under certain conditions. The update can be set to run at a certain time of day or day of the week. A threshold can be set on the number of documents that must change before updating. Here is the syntax for updating an Index. When updating an index without a text table being created, you must specify the column handle.

db2tx UPDATE INDEX table-name [HANDLE handle-column-name]

Automated index updates can be configured by modifying the index settings. The index settings can be displayed and updated using the following commands. The parameter value used to automate index updates is UPDATEFREQ. See the Text Extender Administration Guide for a complete list of index settings and options. When updating an index that does not have a text table, you must specify the column handle.

db2tx GET INDEX SETTINGS table-name [HANDLE handle-column-name]
db2tx CHANGE INDEX SETTINGS table-name [HANDLE handle-column-name] parameter-name
 parameter-value
					

When an index is updated, the new database information is added to an existing index. Over time, an index tree may no longer be balanced, which results in reduced performance. To help improve performance, the index should be reorganized. Here is the syntax to reorganize an index (indexes without a text table must include the column handle).

db2tx REORGANIZE INDEX table-name [HANDLE handle-column-name]

When a problem is detected, an error event record is written to the database. The index experiencing the problem will create a table with the same name as the index handle. The current state of the index can be viewed using the GET INDEX STATUS command. This command will tell you the current state of the index and whether an error event was recorded. If there was an error event, it can be read by running a SELECT query on the index event table. Under some error conditions, the status of the index will be changed to unavailable. To recover from such a condition, the index status must be reset. Here is the syntax for viewing the index status and performing a reset:

db2tx GET INDEX STATUS table-name [HANDLE handle-column-name]
db2tx RESET INDEX STATUS table-name [HANDLE handle-column-name]