LOCAL_RESERVED_DBSPACE_MB option

Function

Controls the amount of space Sybase IQ reserves in the IQ Local Store on a multiplex query server.

Allowed values

Integer greater than zero, in megabytes

Default

200; Sybase IQ actually reserves the minimum of 200MB or 50% of the size of the last dbspace

Scope

Can be set only for the PUBLIC group. DBA permissions are required to set the option. You must shut down and restart the database server for the change to take effect.

Description

LOCAL_RESERVED_DBSPACE_MB 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. 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 or 50% of the size of the last dbspace, which helps DBAs avoid out-of-space conditions by reserving more space automatically.

See also

Reserving space to handle out-of-space conditions in Chapter 5, “Working with Database Objects” in the Sybase IQ System Administration Guide.