Move existing audit data and indexes to new areas
with auditreconfig to re-size the Audit Archive Storage areas:
1. Ensure existing audit data is exported with PROUTIL AUDITARCHIVE, otherwise auditreconfig is going to delete all auditing records
2. Create new Type II Storage Areas to associate the audit tables with then use auditreconfig to restructure:
$ proutil <dbname> -C auditreconfig tablearea <new-table-area-name> indexarea <new-index-area-name> -user <Audit Data Archiver>
The operation will delete all auditing data records.
You must archive auditing data first.
Have you archived the data already and do you want to continue? (Y/N) (16987)
Auditreconfig started. (16973)
Reconfiguring tables ... (16979)
Auditreconfig completed. (16975)
3. Truncate the bi file:
$ proutil <dbname> -C truncate bi
4. Delete the extents on the old audit area(s) until all extents are deleted. Extents will be removed from the last extent to the first extent in the area.
$ prostrct remove <dbname> d "OE Audit Data"
$ prostrct remove <dbname> d "OE Audit Indexes"
For further clarification on the AUDITRECONFIG functionality, refer to the Documentation:
OpenEdge Data Management: Database Administration, Auditing, Reconfiguring Audit Areas