Reducing the WebSphere Sensor Events database size
How can the disk space required for the IBM WebSphere Sensor Events database be minimized?
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.
DELETE FROM SAGE."EVENT" WHERE EVENT_DTS BETWEEN "2012-08-27 00:00:00" AND "2012-08-28 00:00:00";