Audit Detail Delete/Archive
Use Audit Detail Delete/Archive (36.23.1) to delete/archive audit detail information. Unlike other delete/archive programs, this program does not delete each record specified. Instead, for each unique combination of user ID, table, and field, it keeps the latest record and deletes/archives the rest.
To delete and/or archive tables:
1 Back up your database and .df files.
To safeguard against data archived from a previous product version that has different schema, back up the current database definitions (.df) file with each archive/delete run. This lets you reconstruct a corresponding database for data retrieval.
2 Verify record selection.
Run the delete/archive program without deleting or archiving records. This generates a report showing selected records. Review the report and if records selected for deletion are correct, proceed with the actual archive/delete.
3 Run appropriate historical reports such as Invoice History Delete/Archive (7.13.23).
4 Determine selection criteria for the records being deleted, and run the delete/archive program, setting Delete and Archive to Yes.
The program creates a xxyymmdd.hst file in the default directory where xx is the record identifier, such as iv for invoices, and yymmdd is the archive date.
5 Verify deletion of records from the database.
6 Verify the contents of the .hst file using the appropriate operating system command.
7 Back up the .hst file to storage media and delete from system.
The delete/archive program does not reduce database size. To reduce database size, use a dump/load program.