Detailed Field Information Related Information Examples & Tutorials

Database Maintenance Options

Database Maintenance Options provides several advanced settings for maintaining and repairing your database. The settings you choose may be saved to use as defaults whenever maintenance is performed.


Database Maintenance Options

We recommend you backup critical data files before running maintenance since, if the machine is failing, the maintenance, while manipulating data files, may cause undesirable consequences and, potentially, loss of data.

tip.gif Please refer to Backup Database Topics for options for backing up your files.

Database

From the pick list, select the individual database you wish to maintain. Selecting "All Databases" will run the functions you choose on the entire Collect! database device.

Top of page.

Cache Pages

This setting affects the speed of the maintenance functions. It depends on your available system memory. A value of 16384 should result in good performance.

Top of page.

Maintenance Functions

This section lists various types of maintenance that may be selected. Each function may be run on all databases or you may select an individual database from the pick list in the Database section.

Top of page.

Check Records, Sets And Blobs

Switch this ON with a check mark to run dbcheck on all records and set relationships and blobs.

Top of page.

Fix Based On Last Check

Switch this ON with a check mark to run the dbfix utility to repair errors reported when dbcheck was last run.

Top of page.

Keybuild

Switch this ON with a check mark to rebuild the indexes for the selected database. Index files are created and maintained by Collect! and are used to perform fast searches on names, phone numbers and other fields.

Index files can, however, become corrupted at times. Rebuilding index files should be done periodically as a matter of routine maintenance to ensure that your searches are accurate.

Top of page.

Dchain

Switch this ON with a check mark to sort the internal delete chain list for the selected database. This optimizes the reusing of these empty spaces.

Top of page.

UID Check

Switch this ON with a check mark to run a UID check on the selected database. UID Check ensures the integrity of Collect!'s unique record identifiers.

Top of page.

Run Function

Select RUN to start the database maintenance using the settings you have chosen.

Top of page.

Snapshot To

This field displays the current snapshot path. If no path is specified, the Server will fall back to the default, CV11\snapshot folder. The snapshot path is stored in the collect.cfg configuration file.

tip.gif When selecting a path, the path MUST exist. Collect! will not create a path if it does not exist.

Top of page.

Close

Select CLOSE to return to the previous form.

Top of page.

Save As Default

Select SAVE AS DEFAULT to save this configuration for database maintenance to the collect.cfg configuration file. You must restart your CV11 Server to register the new settings.

Top of page.

Help

Select HELP for information on Database Maintenance Options and links to related topics.

Top of page.

See Also

- How To Maintain Your Database
- Database Maintenance Topics

Top of page.

Was this page helpful? Do you have any comments on this document? Can we make it better? If so how may we improve this page.

Please click this link to send us your comments: helpinfo@collect.org