To speed up queries in the MAP_EVENT table, MVF Task Scheduler moves older audit events to the MAP_EVENT_AUDIT table. These records are kept in the MAP_EVENT_AUDIT table for a configurable number of days before being deleted from the database. The CLEAN_MAP_EVENT_AUDIT field in the MVF_TS_CONFIG table determines how often the older audit events are removed from the MAP_EVENT_AUDIT table. By default, records are deleted every Saturday at 3:00.
 | Note: To prevent undo/redo logs from growing too quickly, the MAP_EVENT_AUDIT_MAX_ROWS field in the MVF_TS_MODULE_CONFIG table specifies the number of records to process per transaction. The default is 2000. |
To define when older audit records are deleted from the database
To determine the current settings, type
select * from MVF_TS_CONFIG
To configure when audit records are deleted from the MAP_EVENT_AUDIT table, type:
update MVF_TS_CONFIG set value='minute hour day month weekday' where attribute='CLEAN_MAP_EVENT_AUDIT'
where each of minute hour day month weekday is a numeric value and asterisks (*) are used to represent all. For example, to indicate the default of every Saturday at 3:00, the CLEAN_MAP_EVENT_AUDIT field has the value 0 3* * 6. For hour, 0 represents midnight. For weekday, accepted values are 0–6, and 0 represents Sunday.
After the changes are made, restart MVF Task Scheduler.