The EasySpooler process lpsqueue maintains and rebuilds the database files constantly based on the rebuild pctl and rebuild queue parameters defined on the Miscellaneous tab on the Global Tuning window. The parameters are:
rebuild_pctl_empty_ratio
rebuild_pctl_min_size
rebuild_queue_empty_ratio
rebuild_queue_min_size
Before the database files can be rebuilt they must contain at least the number of entries defined in the minimum file size parameters, this value includes deleted entries.
The ratio of deleted entries to the file size determines when to rebuild the database files. The default values for the minimum file size parameters is 1000 entries and the default ratio is 0.60 (60 percent). If a queue or pctl file contains less than 1000 entries it will never be rebuilt even if all of the entries are deleted. However if there are 1000 or more entries in the files and 600 (60 percent) or more of them are deleted entries, then the files will be rebuilt such that all non-deleted entries are moved to the front of the file and the unused portion of the file is then truncated. This keeps the files from taking up too much disk space with nothing but deleted entries
Consider the parameter settings based on how busy your system is. On a busy system, where new documents are always being spooled, those documents will take up empty space and the rebuild may not need to happen often. However if a large number of documents are spooled in batch and then a long period of time passes where only a few documents are spooled, then it may be necessary to reclaim disk space.
You can also perform file maintenance manually if needed. You may need to rebuild the database files manually if you have very long host names and/or user names and they change on a regular basis.
Rebuilding the database:
Creates a new queue file for the server and writes into it only the active documents and those that could be reactivated
Removes inactive documents.
Rebuilds the printer control (pctl) database
For more information, see the sections lpsqueue and queue in Chapter 2 of the ROC EasySpooler Developer’s Guide. Also see the addp maintenance option in Chapter 2 of the ROC EasySpooler Developer’s Guide.
CAUTION: The process of rebuilding the database may take a few minutes to complete. You must stop ALL processing. We recommend that you put all active documents on hold before continuing. If EasySpooler is currently processing documents, it waits until they are completed.
To manually perform file maintenance:
Click Admin in the main menu and select File maintenance from the menu options.
NOTE: This option is also available on the EasySpooler Server window. Select Admin from the main menu. Select EasySpooler server from the first drop-down menu options and select Server status from the second drop-down menu options. The File maintenance is under the Tools section of the window.