Controls the amount of space Sybase IQ reserves in the IQ Main 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. Requires DBA permissions to set the option. Shut down and restart the database server for the change to take effect.
MAIN_RESERVED_DBSPACE_MB lets you control the amount of space Sybase IQ sets aside in your IQ Main Store 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.
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.
