Controls the amount of space Sybase IQ reserves in the IQ Local Store on a multiplex query server.
Integer greater than zero, in megabytes
Can be set only for the PUBLIC group. DBA authority is required to set the option. You must shut down and restart the database server for the change to take effect.
200; IQ actually reserves the minimum of 200MB and 50% of the size of the last dbspace
This option lets you control the amount of space Sybase IQ sets aside in your IQ Local Store on a particular query server for certain small but critical data structures used during release savepoint, commit, and checkpoint operations. For a production database, set this value to between 200MB and 1GB. The larger your IQ page size and number of concurrent connections, the more reserved space you need.
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,” Sybase IQ System Administration Guide.
