How to reduce / reclaim index space used by OpenEdge Audit indices after auditarchiver run.

After performing and audit archive the index information does not appear reduced.

The exact cause is not known at this time.

Here are the indices that will most likely benefit from periodic index compaction.
_AppContext-Id
_Audit-time
_Connection-id
_Data-guid
_Event-context
_Event-group
_EventId
_Userid
_Continuation-seq
These are the main consumers of space.


To begin, perform a dbanalysis of just the audit areas which store the index information.

Example of command assuming database name is "audit" and the area which holds the audit indices is "Audit_Index":
proutil audit -C dbanalys "Audit_Index" >audit_dbanalysis_before.txt

After the index compactions have been completed run another dbanalysis to confirm the space utilization of the area is improved.

Example of command assuming database name is "audit" and the area which holds the audit indices is "Audit_Index":
proutil audit -C dbanalys "Audit_Index" >audit_dbanalysis_after.txt

Here are some examples of the command to compact the indices for these assuming the database name is "audit":
proutil audit -C idxcompact _aud-audit-data._AppContext-id
proutil audit -C idxcompact _aud-audit-data._Audit-time
proutil audit -C idxcompact _aud-audit-data._Connection-id
proutil audit -C idxcompact _aud-audit-data._data-guid
proutil audit -C idxcompact _aud-audit-data._Event-context
proutil audit -C idxcompact _aud-audit-data._Event-group
proutil audit -C idxcompact _aud-audit-data._eventid
proutil audit -C idxcompact _aud-audit-data._userid
proutil audit -C idxcompact _aud-audit-data-value._Continuation-seq 

In 11.7 the reduction of index space used by auditing information is handled inline to the audit archive operation so index compaction may not be necessary.