Administering the event table

If a text search index is updated frequently, you can reduce the size of the event table by removing old event entries.

Procedure

To remove event entries from the event table:

Issue the DELETE command for the entries that you want to remove.

For example, you can use the following statement to remove events that occurred before a certain date, where index-ID is the index ID:

DELETE FROM SYSIBMTS.EVENTS_index-ID E 
  WHERE DATE(E.TIME) < '2007-01-01'