Deleting old records from the Event table

Auditing events are stored in the Event table. Over time, many records can accumulate in the Event table, which can cause the performance of the auditing feature to degrade. To prevent the Event table from storing too many records, consider configuring an audit disposition schedule to automate the deletion of Event table records that you no longer need.

After Event table records are deleted, FileNet® P8 components no longer have access to events information through the AuditedEvent enumerated properties. If you require access to the deleted information at a later date, you must make copies of the Event table records before they are deleted from FileNet P8 . You can make copies of the Event table records by:
  • Copying the Event table records into another table in another database
  • Exporting the Event table records into an export file

For more information about audit disposition scheduling, see Pruning audit entries.

Attention:
After deletion or truncation, FileNet P8 applications no longer have access to events information through the AuditedEvent enumerated properties. You can save events for access through non-FileNet P8 applications by inserting the event rows into another table in another database or by exporting them to an export file before performing the deletion or truncation.