Use SQL Sorting on Disk (-SQLTempDisk) to define the size of the temporary file for backup storage for SORT and temp-table operations.

Operating system and syntax UNIX / Windows -SQLTempDisk value
Use with Maximum value Minimum value Single-user default Multi-user default
SQL — — 500000 500000
value
Maximum size supported for temporary file for backup storage. This is the maximum amount of data that can be sorted.

Increase -SQLTempDisk only when you encounter a SQL operation involving temp tables, such as sorting fails because a limit has been reached.

The SQL Sorting on Disk (-SQLTempDisk) 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: The SQL Sorting on Disk (-SQLTempDisk) parameter is used only if the startup parameter -SQLTempMgr Legacy is used. In ordinary use, -SQLTempDisk is ignored and has no effect.