SQL Sorting Memory (-SQLTempBuff)

Use SQL Sorting Memory (-SQLTempBuff) to define the amount of memory to use as a data buffer for each SORT operation.

Operating system and syntax UNIX / Windows -SQLTempBuff value
Use with Maximum value Minimum value Single-user default Multi-user default
SQL — 8 1000 1000
value
Size in K-bytes of memory to use for each SORT operation.

This is a performance-tuning parameter and is not ordinarily required.

The SQL Sorting Memory (-SQLTempBuff) parameter may be modified while your database is online using PROMON or through the _DbParams VST. This change will only take effect on the primary broker and its newly spawned servers.

Note: Each connection allocates one temporary table buffer.