Compacting your DVMAX Datafile (v7.5 and Higher)

Operating Systems: Macintosh and Windows

Applies to Versions: 7.5 and Higher

Compacting your datafile can be done as routine maintenance to help keep the health and performance of your database running smoothly. A compaction can described as something similar to doing a defrag on your computer's hard drive. Instead, a compaction will "defrag" just your database.

Note: A compaction requires the DVMAX database to be OFFLINE. No one will be able to use DVMAX during the compaction.

Time Required: The time it takes to complete the compaction could be anywhere from several minutes to hours depending on the size of your data and speed of your hard drive.

To Compact the Data

Go to the DVMAX Server User Interface

Note: The DVMAX Server User Interface will have multiple tabs across the top: Monitor, Users, Processes, Maintenance, Application Server, SQL Server, and HTTP Server. If you have launched DVMAX and do not see the User Interface with these options, click on the Window drop down menu at the top and choose Administration.

- Click on the Maintenance Tab

- Click Compact Data

- Choose to Disconnect all Users and Quit (if you're ready to proceed)

- DVMAX will start compacting the database, showing several dialogs as it steps through each table.

- The compaction will complete when the dialogs cease and the Server application restarts itself.

- If you decide to not monitor DVMAX during the compaction, check the Application Server tab and check the Uptime. If the Uptime changes to something more recent, you'll know the Server has rebooted while you were away.