Clearing text search index events

If you no longer need the messages in the event view of an index, you can clear (delete) them.

Before you begin

For details, including authorization requirements, see the description for the CLEAR EVENTS FOR INDEX command or the SYSTS_CLEAR_EVENTS procedure.

About this task

Information about indexing events, such as the update start and end times, the number of indexed documents, or document errors that occurred during the update, are stored in the event view of a text search index. This information can help you determine the cause of a problem.

Procedure

To clear the event view of a text search index, use one of the following methods:

Run the db2ts CLEAR EVENTS FOR INDEX command, as follows:
```
	db2ts "CLEAR EVENTS FOR INDEX index-name FOR TEXT"
```

Use the SYSPROC.SYSTS_CLEAR_EVENTS administrative SQL routine, as follows:

	CALL SYSPROC.SYSTS_CLEAR_EVENTS('index-schema', 
'index-name', 'locale', ?)