Use this screen to rebuild the database key files. These files, which are sometimes known as index files, contain the information that is needed to quickly locate customers, orders and code definitions. The key files contain redundant information and can always be reconstructed from the main data files. The main data files are file numbers 1 through 10 and the key files are file numbers 11 through 14.
If the key files become corrupted, then the Check database program will report errors such as these:
missing optional key
optional key with missing record bit
xxxx has a missing key
page's slot-count=nnnn is out of range
deleted page found on the b-tree
key-prefix=nnn is out of range
record-dba=n:nnnn is invalid
record-dba=n:nnnn is deleted
record-dba=n:nnnn has invalid record-id and/or inconsistent dba
data does not match record-dba=n:nnnn data
node is not referenced by either the b-tree or delete chain
node is the child of more than one parent
node is not deleted, but is on delete chain
node is deleted, but is not on delete chain
Running the 'Rebuild key files' program will fix these errors. Usually you will perform this operation only on the advice of someone in the CWC Technical Support department.
For a very large database (more than a million customer names) rebuilding the key files may take several hours. You can minimize the amount of time required by running the QuickFill program on the machine where the database files are stored. This will allow the rebuild program to have direct access to the database files and will avoid the delays caused by transferring the data over your network. If you do this, be sure to open the QuickFill database using a local path (typically the C drive). Using a UNC share name containing double slashes or a mapped network drive letter will be slower.
If you have the multiuser version of QuickFill you must be in single user mode to rebuild the key files. To switch to single user mode first make sure that all other users of this database have exited from the QuickFill application program, then select 'Single user' option from the 'File' menu.
Reason for rebuild
Whatever you type in this field will appear in the heading of the report file produced by the Rebuild operation. You can leave this field blank if you wish.
Rebuild Now
When you click this button the rebuild operation will begin immediately. You cannot schedule a rebuild for later execution by placing it on a job list.