Disable auditing using either "Disable - Prepare for Archive" or "Disable - Interrupt Audit" and running the Audit Trail Update Tables report.
|Disable - Prepare for Archive||Copies the current values of all rows in the audited table into the shadow table, and then disables the auditing triggers. There is no longer any recording of any changes. You should archive the shadow table before you purge it.|
|Disable - Interrupt Audit||Modifies the triggers to store one "final" row in the shadow table for each row that is modified in the audit table (remember that a given row in the shadow table represents the data in the audited row before an update). If a row in the table being audited is changed again (a second time), that change is not recorded. The shadow table grows slowly, until it contains one row for each row in the table being audited. Then there is no longer any recording of any changes.|
You should archive the information in the shadow tables according to your business needs.
Before you restart auditing, you should clean out the shadow table. If there were transactions during the time auditing was disabled, and you did not clean out the shadow table, the data in the shadow table would be invalid because it would have a gap where transactions were not recorded. You purge the shadow table(s) by setting the audit group to Disable - Purge Table and running the Audit Trail Update Tables report.
|Disable - Purge Table||Drops the auditing triggers and views and deletes all data from the shadow table.|
You restart auditing by setting the audit group to Enable Requested and running the Audit Trail Update Tables report again.
Attention: If you disable using Disable Purge Table and then reenable auditing for a table, AuditTrail flushes the contents of the shadow table when auditing is reenabled. You should archive any shadow table data that you want to keep before you reenable auditing.
Reporting on AuditTrail Data
Setting Up Release 11 AuditTrail
Release 10.4 AuditTrail Tables, Triggers and Views
Reporting on Release 11 Audit Information