Preallocating Space for a Dbspace

Preallocate space for a catalog dbspace.

Prerequisites

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

The SAP Sybase IQ resource is authenticated and running.
In a multiplex configuration, the coordinator node is running.

Task

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

SAP 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, expand IQ Servers > Space Management, and then select 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.