The default values of some database options have changed in Sybase IQ 15.0:
The default value for the STRING_RTRUNCATION option changed from OFF to ON. This value changes for newly created databases.
The default value of the 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 new MAX_TEMP_SPACE_PER_CONNECTION database option for all DML statements, including queries. For more information, see “Quota management for IQ temporary store”.
The default value of the TEMP_SPACE_LIMIT_CHECK database option has changed to ON from OFF.
