Change the default record expiry time

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.

  1. Edit the purger configuration files for your data loaders.
    • For EGO data loaders, edit EGO_TOP/perf/conf/purger/purger_ego.xml.

    • For Symphony data loaders, edit EGO_TOP/perf/conf/purger/purger_soam.xml.

    • For LSF data loaders, edit $LSF_TOP/perf/conf/purger/purger_lsf.xml.

  2. In the <TableList> tag, edit the Duration attribute to your desired time in days, up to a maximum of 31 days.
    For example, to have the records purged after 7 days:
    <TableList Duration="7">

    By default, the records are purged after 14 days.

  3. Restart the purger service.