/
Compacting your DVMAX Datafile (v7.5 and Higher)

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.

 

Related content

Compacting your DVMAX Datafile (Windows)
Compacting your DVMAX Datafile (Windows)
More like this
Checking the integrity of your datafile in DVMAX Research
Checking the integrity of your datafile in DVMAX Research
More like this
Datacheck - Checking the integrity of your DVMAX datafile
Datacheck - Checking the integrity of your DVMAX datafile
More like this
Backup Configuration for DVMAX
Backup Configuration for DVMAX
More like this
Datacheck: Checking your Datafile's Integrity (Windows)
Datacheck: Checking your Datafile's Integrity (Windows)
More like this
Installing DVMAX 7.0.12r6 Server
Installing DVMAX 7.0.12r6 Server
More like this