Clearing index events

Summary
When
When you no longer need the messages in an index's event table.
Command
CLEAR EVENTS FOR INDEX
Authorization
CONTROL on the table

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 index's event table. This can help you determine the cause of the problem. When you no longer need these messages, you can delete them.

The following example deletes messages from the specified text index:

db2text CLEAR EVENTS FOR INDEX comment FOR TEXT