Altering a text search index

You can alter the update properties of a text search index.

Before you begin

For details, including authorization requirements, see the description for the ALTER INDEX command or the SYSTS_ALTER procedure.

Procedure

To alter an index, use one of the following methods:

Run the following command:
```
db2ts "ALTER INDEX index-name FOR TEXT update-characteristics"
```
Where update-characteristics is a characteristic such as the update frequency of the text search index.
Call the SYSPROC.SYSTS_ALTER administrative SQL routine:
```
CALL SYSPROC.SYSTS_ALTER('db2ts', 'myTextIndex', 'alter-option', 'en_US', ?)
```
Where alter-option is a characteristic such as the update frequency of the text search index.

Results

The text index properties are updated with the new values, except if the text search index is locked by another operation, in which case an error message is displayed, informing you that the text search index is currently locked and that no changes can be made.

Example

You can use either method to change both the update frequency of a text search index and the minimum number of changes required to trigger an update. (If you do not specify any parameters, the current settings are left unchanged.) For example, to change the update frequency for the text search index MYTEXTINDEX so that it is updated from Monday to Friday at 12 noon and 3 p.m., provided that at least 100 changes have occurred to the indexed column, issue the following command:

	db2ts "ALTER INDEX MYTEXTINDEX FOR TEXT   
	UPDATE FREQUENCY d(1,2,3,4,5) h(12,15) m(00) UPDATE MINIMUM 100"

To stop the periodic updating of MYTEXTINDEX, issue the following command:

	db2ts "ALTER INDEX MYTEXTINDEX FOR TEXT UPDATE FREQUENCY NONE"