MAX_TEMP_SPACE_PER_CONNECTION option

Function

Limits temporary store space used per connection.

Allowed values

Integer (number of MB)

Default

0 (no limit on temporary store usage)

Scope

DBA permissions are required to set this option. Can be set temporary for an individual connection or for the PUBLIC group. Takes effect immediately.

Description

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.

Examples

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

See also

“QUERY_TEMP_SPACE_LIMIT option”