Controls the amount of space SAP Sybase IQ reserves in the temporary IQ store.
200; SAP Sybase IQ actually reserves a maximum of 50% and a minimum of 1% of the last read-write file in IQ_SYSTEM_TEMP
Option can be set at the database (PUBLIC) level only.
Requires the SET ANY SYSTEM OPTION system privilege to set this option. Takes effect immediately. The server does not need to be restarted in order to change reserved space size.
TEMP_RESERVED_DBSPACE_MB lets you control the amount of space SAP Sybase IQ sets aside in your temporary IQ store for certain small but critical data structures used during release savepoint, commit, and checkpoint operations. For a production database, set this value between 200MB and 1GB. The larger your IQ page size and number of concurrent connections, the more reserved space you need.
Reserved space size is calculated as a maximum of 50% and a minimum of 1% of the last read-write file in IQ_SYSTEM_TEMP.