Limits temporary store space used per connection.
Integer (number of MB)
0 (no limit on temporary store usage)
DBA permissions are required to set this option. Can be set temporary for an individual connection or for the PUBLIC group. Takes effect immediately.
By controlling space per connection, this option enables DBAs to manage the space for both loads and queries. If the connection exceeds the run time quota specified by MAX_TEMP_SPACE_PER_CONNECTION, Sybase IQ rolls back the current statement and returns this message to the IQ message file or client user:
The current operation has been cancelled: Max_Temp_Space_Per_Connection exceeded
Conditions that may fill the buffer cache include read or write errors, lack of main or temp space, or being out of memory. Sybase IQ may return the first error encountered in these situations and the DBA must determine the appropriate solution. For more information, see Error Messages and Chapter 14, “Troubleshooting Hints” in System Administration Guide: Volume 1.
This statement sets a 500GB limit for all connections:
SET OPTION PUBLIC.MAX_TEMP_SPACE_PER_CONNECTION = 512000
This statement sets a 10TB limit for all connections:
SET OPTION PUBLIC.MAX_TEMP_SPACE_PER_CONNECTION = 10485760
This statement sets a 5000MB limit for user wilson:
SET OPTION wilson.MAX_TEMP_SPACE_PER_CONNECTION = 5000
