Preallocating Space for a Dbspace

Preallocate space for a catalog dbspace.

Prerequisites
DBA authority is required.
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, highlight the resource and select Resource > Administration Console.
  2. In the left pane of the Administration Console view, select IQ Servers > Space Management > Dbspaces.
  3. In the Dbspaces view, highlight the dbspace.
  4. Hover the mouse pointer over the dbspace name and click the arrow.
  5. Select Pre-allocate Space.
  6. Specify a number and unit, for example, 2 megabytes.
  7. 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