hcidbdefrag

This command reclaims disk space.

Note: If you have a defined database alert, then you must shut down the MonitorD process and Lock Manager before running this command. For example, a defined database alert can be message archiving or error database. Running hcidbdefrag with these alerts produces an error.

Whenever a record is deleted from the database, it is marked for reuse and put on the delete chain. It is not physically removed from the file. These free (deleted) records occupy a substantial amount of disk space, especially if a database has had numerous records inserted with many marked as deleted.

This utility moves all valid records to the front of a data file and all deleted slots to the end of the data file. The data file is then truncated to reclaim disk space.

hcidbdefrag [-A] [-r] [-e] [-i] [-m [-s threadname]] [-t] [-q] [-v]
  • -A defrags all databases.
  • -r defrags the recovery database.
  • -edefrags the error database.
  • -idefrags the ICL registry database.
  • -m defrags the Message Archive database cache.
  • -s threadnamethreadname.
  • -t defrags the message tracing database cache.
  • -q suppresses all output, except errors.
  • -v specifies verbose operation. This shows detailed output of the operations performed on the database. defrags the message archive database cache for