Thanks everyone!
We are a public company and the auditors got wind that DBAs could back door into the database and make changes (editor), without any traceability, so we have to come up with a solution to track CUDs. My partner suggested that AI files could be a solution to write ABL code to get the auditors off our back. We are concern with OE auditing would hinder database performance. I think you or someone said you will see a 10 percent decrease in performance. i have a plan, and created some scripts to archive data to another server/DB.
OpenEdge Database Auditing
Auditing goal can be achieved through below steps:
1. Enabling Audit in a DB.
2. Implementing policies.
3. Generating reports.
MXOpen Production Databases
SPSX Audit Archival Utility
EDBPRO EDBTEST
Application DBs Long Term Storage
Reporting
Audit Data
.abd file
_proutil db-C auditarchive _proutil db -C auditload