Kbase P39564: Understanding the new -SG Sort Group parameter for IDXBUILD
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
08/02/2009 |
|
Status: Verified
GOAL:
Understanding the new -SG Sort Group parameter for IDXBUILD
GOAL:
What is the -SG parameter?
GOAL:
Why should the -SG Sort Groups parameter be used for?
FACT(s) (Environment):
Progress 9.1D
OpenEdge 10.0A
FIX:
A new parameter for the IDXBUILD function of Proutil was added in 9.1D07.
This new parameter -SG aims to optimize I/O operations at the disk drive layer. It determines the number of sort groups helping the rebuild utility to make efficient use of memory and disk in sorting indexes. In prior versions of Progress only one file was used to perform all sort and merge operations during the IDXBUILD.
Using the new -SG parameter individual files will be created up to the limit of -SG which is 64. If no value is defined for -SG the default of 48 files will be used to perform all sort and merge operations.
Example of new syntax:
proutil <database name> -C idxbuild -TB 31 -TM 32 -SG 64 -B 5000
Based on this example the command will use 64 files to perform the idxbuild sorting and merging of the indices which are being rebuilt.
If a significant amount of space (tables larger than 2 gigabyte in size) will be indexed then please review the solution regarding using a multi-volume .srt file to define the locations you wish space to be used from.
A large -SG value requires more memory allocation and more file handles. To determine the amount of memory (in kilobytes) needed for each index group, add 1 to the merge number (the merge number is the value assigned to -TM) and multiply the sum by the speed sort block size (the speed sort block size is the value assigned to -TB).
Beginning in 9.1D07 Index build supports sort files larger than 2 gigabyte if the operating system and file system are also configured to support large files.
If the operating system, file system or Progress does not allow large files then review the following solution on multi-volume sort files.
P55740, "How to scope and define a multi-volume srt file for idxbuild"
When Progress now uses sort files, the naming convention of the files will be saa - szz