Kbase 36426: How to define a multi-volume sort file for idxbuild
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Solution ID: P6426
GOAL:
How to define a multi-volume sort file for "idxbuild"
FIX:
Using a file <dbname>.srt for "multi sort files" was introduced in Progress Version 8.0B. It overcame either the 2GB limit of the sort file or space limits within your directories.
A file named <dbname>.srt needs to be created within the directory where <dbname>.db resides. That file describes the amount of space you want to be allocated for sorting within different directories.
A specific syntax for <dbname>.srt must be respected. A trailing / (slash on UNIX), or \ (backslash for Windows platforms) is required and you must not use tab characters in this file; instead use spaces when needed. Moreover, there must be no empty lines, not even at the end of the .srt file.
For example, on UNIX you have a <dbname>.srt like this if you have 500Mb (512,000Kb) free within /usr/sort1, 200Mb (204,800Kb) free within /usr/sort2 and unlimited space in /usr/test:
512000 /usr/sort1/
204800 /usr/sort2/
0 /usr/test/
Within the database log file, <dbname>.lg, you will see output like this:
Temporary sort file at /usr/sort1/ will use up to 512000K of disk space.(5289)
Temporary sort file at /usr/sort2/ will use up to 204800K of disk space.(5289)
Temporary sort file at /usr/test/ will use the available disk space. (5288)
...
Temporary sort file at /usr/sort1/ used up 512000K of disk space. (5283)
Temporary sort file at /usr/sort2/ used up 204800K of disk space. (5283)
Temporary sort file at /usr/test/ used up 18800K of disk space. (5283)
A total of 735600K of temporary sort disk space was used. (5284)
If idxbuild aborts because it has hit the 2GB limit for the sort file, because it has filled the file system, or because you abort it knowing it is going to hit the 2GB limit, you can recover by creating a valid <dbname>.srt file and then re-run the idxbuild. In this case, you see the following:
Previous index rebuild was interrupted. This is a new try. (2748)
Can't find selected index list file .xb; assuming ALL. (2786)
Is this correct? (y
)
Choosing "y" will start the Index Rebuild, and the new .srt file will be used.