IBM Support

Reducing the WebSphere Sensor Events database size

Technote (FAQ)


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 to false; and
  • the Message sector to ibmse='off' under the 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";

Related information

Persistence Task Agent
A Japanese translation is available

Document information

More support for: WebSphere Sensor Events

Software version: 7.0

Operating system(s): AIX 64bit, Linux, Windows, Windows 2003 server

Reference #: 1610830

Modified date: 2012-12-11