The MAP_EVENT_DAYS field in the MVF_TS_MODULE_CONFIG table specifies the number of days current audit records are kept in the MAP_EVENT table; the default is 1 day. The MAP_EVENT_AUDIT_DAYS field in the MVF_TS_MODULE_CONFIG table specifies the number of days older audit records are kept in the MAP_EVENT_AUDIT table; the default is 60 days.
 | CAUTION! Do not change the values of MAP_EVENT_AUDIT_STATE and MAP_EVENT_AUDIT_STATE_BYTES. |
We recommend that you leave MAP_EVENT_DAYS at the default value of one day and that you do not set MAP_EVENT_AUDIT_DAYS to more than 180 days or the MAP_EVENT_AUDIT table may run out of space.
To configure the length of time audit events are stored in the database
To determine the current settings, type
select * from MVF_TS_MODULE_CONFIG
To change the number of days current audit records are stored in the MAP_EVENT table, type
update MVF_TS_MODULE_CONFIG set value='number_of_days' where attribute='MAP_EVENT_DAYS'
or
To change the number of days older audit records are stored in the MAP_EVENT_AUDIT table, type:
update MVF_TS_MODULE_CONFIG set value='number_of_days' where attribute='MAP_EVENT_AUDIT_DAYS'
After the changes are made, restart MVF Task Scheduler.