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.
Example
For example, you can use
the following command to remove
events that occurred before a certain date:
DELETE FROM SYSIBMTS.EVENTS_[N] E WHERE DATE(E.TIME) < '2007-01-01' where
[N] is the index ID.