Reducing the WebSphere Sensor Events database size

Technote (FAQ)


Question

How can the disk space required for the IBM WebSphere Sensor Events database be minimized?

Answer

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";

Related information

Persistence Task Agent
A Japanese translation is available

Rate this page:

(0 users)Average rating

Add comments

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

Translate my page

Machine Translation

Content navigation