Preallocating Space for a Dbspace

Preallocate space for a catalog dbspace.

Prerequisites

Database Version	Dbspace Privileges
SAP Sybase IQ 15.3 and 15.4	Requires one of: DBA authority. SPACE ADMIN authority.
SAP Sybase IQ 16.0	Requires MANAGE ANY DBSPACE system privilege.

The SAP Sybase IQ resource is authenticated and running.

Task

This operation is valid only for catalog dbspaces. You cannot preallocate space for a dbspace in the IQ Main or RLV stores.

Sybase IQ automatically increases the size of catalog DB files as additional space is needed. If your database has a high rate of change, you can preallocate disk space for dbspaces. Proper preallocation reduces fragmentation and improves performance.

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the left pane, select IQ Servers > Space Management > Dbspaces.
Select a dbspace from the right pane and either:
- Click the arrow to the right of the name and select Pre-allocate Space, or
- From the Administration Console menu bar, select Resource > Pre-allocate Space.
Specify space to preallocate and the unit of measure, for example, 2 megabytes.
Click OK.