Creating a Dbspace

Add a new dbspace to the database.

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.
Task
  1. In the Perspective Resources view, select the resource and select Resource > Administration Console.
  2. In the left pane, select IQ Servers > Space Management > Dbspaces.
  3. Click the arrow next to Dbspaces and select New.
  4. On the General Details page, specify:
    Option Description

    Resource

    		 From the list, select the resource for which the dbspace will be created.

    Name of dbspace to create

    A unique name for the new dbspace.

    Store

    The store in which to create the new dbspace: Catalog (for IQ metadata), IQ Main (for IQ user data) or RLV (Row-Level Versioning store for in-memory data).

    Note: Only one dbspace can be created in the RLV store. RLV is applicable in IQ 16.0 for a simplex resource.

    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. Default value is 1.
  5. Click Next.
  6. On the DB Files page, click Add to add files to the dbspace.
  7. In the DB File Details view, 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 Space you allocate to the DB file in kilobytes (KB), megabytes (MB), gigabytes (GB), or terabytes (TB). Unavailable on raw devices; required if the file is not on a raw device. Minimum file size is 8 MB.
    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 Finish.
Parent topic: Dbspaces
Related tasks
Deleting (Dropping) a Dbspace
Preallocating Space for a Dbspace
Generating Dbspace DDL Commands
Changing a Dbspace to Read-Only
Viewing or Modifying Dbspace Properties
Granting Dbspace CREATE Permission
Revoking Dbspace CREATE Permission
Authenticating a Login Account for a Managed Resource
Related reference
Dbspace Privilege Summary