Use SQL Temp Table Data Page (-SQLTempPageSize) to define the size of the temporary table data page.

Operating system and syntax UNIX / Windows -SQLTempPageSize value
Use with Maximum value Minimum value Single-user default Multi-user default
SQL 8 1 8 8
value
Size in K-bytes.

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

SQL Temp Table Data Page (-SQLTempPageSize) 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.

Notes

  • The SQL Temp Table Data Page (-SQLTempPageSize) parameter is used only if the startup parameter -SQLTempMgr Legacy is used. In ordinary use, -SQLTempDisk is ignored and has no effect.
  • The value-SQLTempPageSize must be set to either 1 or 8. Progress recommends setting this parameter to 8.