To reduce or increase the number of records stored in the database, change the duration
of time that a record is stored in the database before it is purged. This applies to all tables in
the database unless you also specify the record expiry time in a particular table.
Procedure
-
Edit the purger configuration files for your data
loaders.
- For EGO data loaders, edit
EGO_CONFDIR../../perf/conf/purger/purger_ego.xml.
- For IBM® Spectrum Symphony data loaders, edit
$EGO_CONFDIR../../perf/conf/purger/purger_soam.xml.
-
In the <TableList> tag, edit the Duration
attribute to your desired time in days, up to a maximum of 365
days.
For example, to have the records purged after 7
days:
<TableList Duration="7">
By default, the records are purged after 14 days.
-
Restart the purger service.