Reducing the WebSphere Sensor Events database size

The WebSphere Sensor Events database size can be minimized by not writing event data to the report tables. This is accomplished by setting -

• the Persistence Task agent property write.to.report.tables to false; and
• the Message sector to ibmse='off' under the ibmse.persistence.as parameter under the JMS activation specification.
  

If event data has already been written to the database, it can be deleted by a query based on date range like the example below. Deleting the record related to a specific event from the SAGE.EVENT table will also delete the records related to the same event from the other 2 tables, namely SAGE.EVENT_COMPOUND_ELEMENTS and SAGE.EVENT_SIMPLE_ELEMENTS.

DELETE FROM SAGE."EVENT" WHERE EVENT_DTS BETWEEN "2012-08-27 00:00:00" AND "2012-08-28 00:00:00";