Constrains the use of temporary IQ dbspace by user queries.
Any integer
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.
2000 MB
If Sybase IQ receives a query that requires a temporary result space larger than value of this option, it rejects the query with the following message:
Query rejected because it exceeds total space resource limit
If you set this option to zero, there is no limit and no queries will ever be rejected based on their temporary dbspace requirements.
