|
WSupported on Windows
|
USupported on Unix
|
|
NSupported in Synergy .NET
|
The SORTMEMMAX environment variable specifies the upper memory limit used by the SORT statement when determining the optimal sort memory size.
Value
The number of kilobytes of memory that the sort should not exceed when allocating sort memory. The default value is 65536 on Windows and 4096 on Unix (for 64 MB and 4 MB, respectively). The minimum value allowed is 512, and there’s no maximum limit.
Discussion
SORTMEMMAX is used by the SORT verb in the runtime, either locally or when both files specified to the SORT are remote. SORTMEMMAX is used on the server when the sort is on the server. It is used by the runtime when the sort is local and not on a server.
Setting location
For a local file, in the environment or synergy.ini (Windows).
On a Windows server, in the Windows registry. Use the Synergy Configuration Program, or set SORTMEMMAX as follows:
- For a specific instance of xfServer, set SORTMEMMAX under HKEY_LOCAL_MACHINE\SOFTWARE\Synergex\Synergy xfServer\servername\synrc.
- For a system-wide setting, set SORTMEMMAX under HKEY_LOCAL_MACHINE\SOFTWARE\Synergex\Synergy xfServer\synrc.
On a Unix server, in the synrc file in the /etc directory (for all clients) or the .synrc file in the users $HOME directory (for specific users).
Used by
Runtime, xfServer
Examples
On Unix,
SORTMEMMAX=8192 ;export SORTMEMMAX
