Controls the amount of space Sybase IQ reserves in the Temporary IQ Store.
Integer greater than zero, in megabytes
200; Sybase IQ actually reserves the minimum of 200MB and 50% of the size of the last dbspace
Can be set only for the PUBLIC group. DBA authority is required to set the option. Shut down and restart the database server for the change to take effect.
TEMP_RESERVED_DBSPACE_MB lets you control the amount of space Sybase IQ sets aside in your Main 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.
Sybase IQ reserves the minimum of 200MB and 50% of the size of the last dbspace, which helps DBAs avoid out-of-space conditions by reserving more space automatically.
“Reserving space to handle out-of-space conditions” in Chapter 5, “Working with Database Objects” in the Sybase IQ System Administration Guide
