This command deletes indexing events from an index's event view. Use the event view for administration purposes. The name of the event view is found in the EVENTVIEWNAME column of the DB2EXT.TEXTINDEXES view.
According to DB2 catalog views, the user ID in this command must have CONTROL privilege on the table for which the full-text index was created.
>>-CLEAR-EVENTS-FOR-INDEX---------------------------------------> >--+------------------+--index-name--FOR-TEXT-------------------> '-index-schema-"."-' >--+--------------------+--+----------------------+------------>< '-COMMITCOUNT--count-' '-|connection-options|-' connection-options: |--+--------------------------------------------------------------+--| '-CONNECT-TO--database-name--+-------------------------------+-' '-USER--userid--USING--password-'
When you schedule regular updates using the UPDATE FREQUENCY option in the CREATE or ALTER INDEX commands, regularly check the event table. Use CLEAR EVENTS to clean up the event tables, after you have checked the reason for the event and removed the source of the error.
Try to ensure consistency between the contents of the text columns in the table and the index, especially when re-indexing documents.
You cannot issue the command if one of the following commands is running on the index: