- Gold, 750 points or more
Issue the the dbcompact command to correct the Cisco Secure ACS Solution Engine user database. As is the case with many relational databases, the Cisco Secure ACS Solution Engine user database handles the deletion of records by marking deleted records as deleted. However, it does not remove the record from the database. Over time, the Cisco Secure ACS Solution Engine user database can become substantially larger than is required by the number of users it contains.
To reduce the Cisco Secure user database size, compact it periodically. Database compaction includes three basic operations that take place automatically when the dbcompact command is issued:
- A database dump occurs.
- The database is initialized and removes deleted records.
- The dumped data is loaded back to the database.
This procedure can reduce the amount of space taken up by the database and improve the database response time.
For more details, refer the Compacting the ACS Solution Engine Database section of the Administering Cisco Secure ACS Solution Engine Guide.