VCleanDB is the VADV utility which performs database maintenance. It will scan each of your databases and purge old and deleted records. It also does the daily maintenance the BBS needs.

The ported version adds several enhancements to the original application. It is able to perform user database maintenance and file maintenance.

Command-line parameters:

/COMPACT (/C) - Compact databases to remove orphaned entries. VCleanDB will check each database for messages that are not accociated with any record. If found, it will remove these messages.

/DAILY - Perform daily maintenance. This will reset the "today" statistics and rotate log files. This option is typically ran by the BBS or VADV32 and should only be ran manually in special situations.

/DELFILES (/DF) - Delete any attached file to deleted messages. If a deleted record has an attached file (such as a file database record), if the file is no longer needed then it will be deleted.

/OVERRIDE (/OV) - Run even if a user is online. Normally if a user is currently using the BBS system, VCleanDB will exit without performing any action. This is to ensure that databases will not become corrupted and that the user experience will not be harmed due to deleting database records. You can force VCleanDB to run by using this parameter.

/RESETUSERTIME (/RT) - Reset each user's time counter. This will set each user account to zero minutes used. It must be used with /DAILY. This option is not recommended to be used except in very specific circumstances. The BBS automatically resets the user time counter the first time the user logs on each day.

/SUPERCLEAN (/SC) - This option will clean the database, compact databases and perform user database maintenance. It is the same as running the /COMPACT and /USERMAINT parameters.

/USERMAINT (/UM) - Perform user database maintenance. VCleanDB will scan each user account and fix any issues and clean all deleted user accounts.

/VERSION (/VER) - Version information. This displays the current version number.

/? - Display the available parameters.

It is recommended that you run VCleanDB at least once a day. It is highly recommended that you run it with the SUPERCLEAN option since this will fix issues that can occur with user accounts. It is not recommended that you run it with the DAILY option unless it is absolutely necessary - this is done automatically by the BBS or by VADV32 each day.