Preallocating Space for a Dbspace

Preallocate space for a catalog dbspace.

Prerequisites
Authenticate with Sybase IQ using an account that has DBA authority.
Task

This operation is valid only for catalog dbspaces.

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 pre-allocate disk space for dbspaces. Proper pre-allocation reduces fragmentation and improves performance.

  1. In the Perspective Resources view, select the resource and select Resource > Administration Console.
  2. In the left pane of the Administration Console, expand IQ Servers > Space Management and select Dbspaces.
  3. In the right pane, select a dbspace.
  4. Click the drop-down arrow that appears next to the dbspace name and select Pre-allocate Space.
  5. Specify a number and unit, for example, 2 megabytes.
  6. Click OK.
Parent topic: Manage a Dbspace
Related tasks
Viewing Dbspace Properties
Adding a Dbspace
Modifying a Dbspace
Changing a Dbspace to Read-Only
Deleting a Dbspace
Generating Dbspace DDL Commands