The new database option MAX_TEMP_SPACE_PER_CONNECTION limits the amount of IQ temporary store space used per connection and tracks temporary store usage for all Data Manipulation Language (DML) statements, in addition to queries. For syntax, see “MAX_TEMP_SPACE_PER_CONNECTION option” in Chapter 2, “Database Options,” in Reference: Statements and Options. MAX_TEMP_SPACE_PER_CONNECTION monitors and limits the actual run time temporary store usage by the statement. If the connection exceeds the quota set by the MAX_TEMP_SPACE_PER_CONNECTION option, an error is returned and the current statement rolls back.
The default value of the existing QUERY_TEMP_SPACE_LIMIT database option has changed from 2GB to 0, which means there is no limit on temporary store usage by queries. To limit the temporary store usage per connection, the DBA can set the MAX_TEMP_SPACE_PER_CONNECTION option for all DML statements, including queries.
When a Sybase IQ database is upgraded from an earlier release to version 15.0, the MAX_TEMP_SPACE_PER_CONNECTION database option is set to the default value of 0. You can use sp_iqcheckoptions to find the default and current values of options before and after upgrading, to help determine if the new option settings are appropriate for the upgraded database.
