Defragmenting a Database
Defragmenting a database means to store each individual record in the database in contiguous fashion. The purpose of defragmentation is to optimize access to items.
To defragment a database
- Shut down the server and create a backup of all databases that are connected to the server. For details, see Backing up Rochade Databases.
- Start the defragmentation of the database with this command:
rodbucx<os> [<section>] [<ini_file>] -defrag
‑db=<db_section>
Make sure that you have a current backup of the databases available. If defragmentation is interrupted, the database becomes unusable.
During defragmentation, five temporary files are required for sorting.
By default, the temporary files are created in the current directory. But via the options -sortfl<n> and -numcat, you can specify a different directory for them.
Optionally, you can use the -tempdb option to specify a file to be used as a temporary file for the database by rodbucx<os>.