Starting with Progress 9.1D08 and OpenEdge 10.0A, IDXBUILD can create sort files larger than 2 GB
- irrespective of the database being enabled for large files,
- as long as the filesystem supports large files and
- the user running the idxbuild can create files in the directories the sort files will be created in.
Since the limit on srt files was lifted, there is no longer an implicit reason for having to define a multi volume sort file. It is never-the-less useful when the disk space needed by index rebuild is spread across several file systems or more importantly to minimize disk contention during the sort and merge phases of idxbuild by spreading out the I/O across filesystems.
Starting with OpenEdge 10.0A, the -SS parameter for proutil -C idxbuild extends the functionality from Progress 8 and 9 known as multi volume sort files.
After estimating then defining the disk space needed in the, <dbname>.srt file, the -SS parameter defines where the multi volume sort file -SS path\<name.srt> is found for the index rebuild routines to create/use sort files for the sort and merge phases.
When the -SS option is used, the location specified is used to find the .srt file.
If -SS is not used, the current directory is searched for a <dbname>.srt file. If found, that file is used.
If -T is specified, then that directory will be used for the temporary files (but only if -SS was not used and there is no .srt file located in the current working directory).
Finally, if none of the above, the current working directory is used as the location of all temporary sort files.
|
