Constrains the use of temporary IQ dbspace by user queries.
Any integer
2000MB
DBA permissions are not required to set this option. Can be set temporary, for an individual connection, or for the PUBLIC group. Takes effect immediately.
If Sybase IQ receives a query that requires a temporary result space larger than value of this option, it rejects the query with this message:
Query rejected because it exceeds total space resource limit
If you set this option to zero, there is no limit and no queries are ever rejected based on their temporary dbspace requirements.
