Truncating an Audit Area or Tablemove Audit Tables fails

Audit Areas cannot be Truncated and Audit Tables cannot be Tablemoved
Truncating an Audit Area with PROUTIL -C TRUNCATE fails with error 13683
Tablemove Audit schema with PROUTIL -C TABLEMOVE fails error 8605
Audit Area size cannot be reclaimed with PROUTIL utilities.
After AUDITARCHIVE without nodelete is run, the audit area cannot be resized.

User truncating audit area with Audit Archiver privillege
After disabling auditing the audit area still cannot be truncated
AUDITARCHIVE script didn't run resulting in very large audit areas.
After audit data are archived the Audit Areas cannot be reduced in size
PROBKUP volumes are larger than needed due to Audit Area High Water Mark much higher than necessary

Prior to OpenEdge 11.3, Audit Storage Areas (eg "Audit Data" and "Audit Indexes") cannot be truncated or removed after audit data is exported or Auditing disabled.  This is because audit tables are classified internally by the database as 'Schema' tables just like _file, _field, metaschema. OpenEdge utilities will not allow the truncation of areas holding schema tables nor move schema tables to another area. In effect, the Auditing structure cannot be deleted and truncation of an audit area is not allowed. Auditing may be disabled but the auditing schema will remain unless the database is dumped and loaded.

To prevent the audit areas from growing disproportionately on any audit enabled database, run PROUTIL AUDITARCHIVE at regular intervals.

Should the Audit Areas need re-structuring, upgrade to OpenEdge 11.3 or later where a new feature: "PROUTIL -C AUDITRECONFIG" allows Audit Data Areas to be reconfigured and physical disk space associated with audit trails to be recovered.

Apart from being able to purge all data from existing Audit Areas, the AUDITRECONFIG utility can also be used to split or combine index and data areas and set new records per block and blocks per cluster values by moving existing audit data and indexes to new TYPE II Storage Areas.  

To re-size the Audit Archive Storage areas with AUDITRECONFIG:

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:
3. Truncate the former audit data and index areas:
            $ proutil <dbname> -C truncate area <old-table-area-name>

4. Truncate the bi file:
5. 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. For further clarification on the AUDITRECONFIG functionality, refer to the Documentation:

Prior to OpenEdge 11.3, should the Audit Areas need re-structuring the only way to recover this space is to dump and load the entire database then re-enable auditing.