Adding a Dbspace

Add a new dbspace to the database using the Create Dbspace wizard.

Prerequisites
Authenticate with Sybase IQ using an account that has DBA or Space Admin authority.
Task
  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. Click the drop-down arrow that appears next to Dbspaces and select New.
  4. On the General Details page of the Create Dbspace wizard, specify:
    Option Description

    Resource

    The name of the resource on which to create the new dbspace.

    Name of dbspace to create

    The name of the new dbspace.

    Store
    The IQ store of the new dbspace:
    • Main store
    • Catalog store

    Striping

    Enables or disables disk striping for this dbspace.

    Stripe size (Kb)

    The number of kilobytes (KB) to write to each file before the disk-striping algorithm moves to the next stripe for this dbspace.
  5. In the left pane of the Create Dbspace wizard, select DB Files to add files to the dbspace.
  6. On the DB Files page, click Add.
  7. Specify:
    Option Description

    Logical name

    User-defined name of the DB file.

    Path to physical file on disk

    Path to the physical file on disk. It is usually best to use an absolute path. A relative path works for simplex servers and for multiplexes that use the SCC shared-disk facility and have the SCC installation directory mounted in the same location on each multiplex server host. If you specify a relative path for a simplex that is later converted to a multiplex, the relative path might cause an error.

    Raw device

    A check mark indicates the file is on a raw device.

    File size

    Specify a file size value and units: kilobytes (KB), megabytes (MB), gigabytes (GB), or terabytes (TB). This option is active only if the file is not on a raw device.

    Reserve size

    Specify a reserve size value and units: kilobytes (KB), megabytes (MB), gigabytes (GB), or terabytes (TB).

  8. Click OK to add the file.
  9. Click Back to return to the General Details page to make further changes. When you are finished, click Finish.
Parent topic: Manage a Dbspace
Related tasks
Viewing Dbspace Properties
Modifying a Dbspace
Changing a Dbspace to Read-Only
Preallocating Space for a Dbspace
Deleting a Dbspace
Generating Dbspace DDL Commands