QAD 2017 Enterprise Edition
>
User Guides
>
Security Administration
>
Auditing
>
Archive Database
Archive Database
The system is preconfigured with an archive database (qadarc). Audit trail data is archived to this database. The archive database is a copy of the database with auditing enabled. No other schema needs to be loaded. There are several reasons for having an archive database:
• Audit trail data requirements grow over time, requiring more disk space. Having a separate archive database prevents audit trail data from taking disk space in the application database.
• Running audit reports against the application database will impact system performance.
• The archive database can be deployed in a flexible way.
• The archive database can store audit trail data from different application databases and act as a central reporting database.