The database compact utility searches and scans the database for unused pointers and remnants of deleted items, and removes redundant items from the associated tables. Before compacting a database, Metrics Management first performs a verification to ensure that the logical structures are intact. After compaction, typically the size of database tables decreases and the efficiency of the database increases. If the database compaction fails, contact Actuate Performance Management Customer Support for assistance.
Actuate recommends compacting the database once a month. Compacting more frequently is unnecessary.
After compacting, to refresh the database size in Show Database Properties, take the database offline to restart the database.
Compacting a database is supported for Standard databases only.
How to compact a database
1 In Servers and Databases, select the database to compact.
2 Make the database unavailable.
3 Choose Compact Database. Metrics Management backs up, verifies, and compacts the existing database.
4 After compaction completes, the message displayed in Figure 10‑41 appears. Choose OK.
