Viewing or Modifying Dbspace Properties

View or change the name, mode, status, and striping properties of a dbspace.

Prerequisites
Database Version Dbspace Privileges
SAP Sybase IQ 15.3 and 15.4

View any dbspace property page – none.

Modify dbspace permissions – You must have one of:
  • DBA authority
  • PERMS ADMIN authority
Modify any other dbspace property – you must have one of:
  • DBA authority
  • SPACE ADMIN authority
SAP Sybase IQ 16.0

View any dbspace property page – none.

Modify dbspace permissions – You must have the MANAGE ANY DBSPACE system privilege.

Modify any other dbspace property – you must have the MANAGE ANY DBSPACE system privilege.
Task
You cannot change a dbspace name if it is a system dbspace (with a name beginning with IQ_SYSTEM) or a system catalog dbspace.
  1. In the Perspective Resources view, select the resource, and select Resource > Administration Console.
  2. In the left pane, expand IQ Servers > Space Management, and then select Dbspaces.
  3. Select a dbspace from the right pane and either:
    • Click the arrow to the right of the name and select Properties, or
    • From the Administration Console menu bar, select Resource > Properties.
    The Dbspace Properties view appears.
  4. View or modify the properties.
    • When you are modifying properties, you need not click Apply before changing screens; however, doing so saves any changes.
    • If you do not have privileges to modify properties, SAP Control Center displays the properties view in read-only mode.
    • Some properties are read-only or hidden, based on the dbspace type.
    Area Description
    General

    Name – Name of the dbspace.

    Type – (Read-only) The dbspace type.

    Mode – Mode of the dbspace. Available values are:
    • ReadWrite
    • ReadOnly
    Status – Status of the dbspace. Available values are:
    • Online
    • Offline

    Striping – (IQ Main type only) Enables (On) or disables (Off) disk striping for this dbspace.

    Stripe size – (IQ Main type only) The number of kilobytes (KB) to write to each file before the disk-striping algorithm moves to the next stripe for this dbspace.

    File – (Catalog type only)

    Reallocate Space – (Catalog type only)

    Note:
    • The RLV store dbspace can be renamed if no RLV-enabled tables exist.
    • The mode of the RLV store dbspace can be changed, if the dbspace is online, however ReadOnly mode can only be selected if no RLV-enabled tables exist.
    • The status of the RLV store dbspace can be changed, if the dbspace is in ReadOnly mode.
    • Striping and Stripe Size are not supported for the RLV store dbspace, or cache dbspace.
    DB Files To manage the db files within the dbspace, click the arrow to the right of a db file name and select an option.
    Permissions

    See Granting Dbspace CREATE Permission and Revoking Dbspace CREASTE Permission.
  5. Do one of:
    • Click OK to update any changes to the database and exit the properties view.
    • Click Apply to update any changes to the database, but remain in the properties view.
    • Click Cancel to cancel any changes not updated to the database and exit the properties view.
Parent topic: Dbspaces
Related tasks
Creating a Dbspace
Deleting a Dbspace
Preallocating Space for a Dbspace
Generating Dbspace DDL Commands
Changing a Dbspace to Read-Only
Granting Dbspace CREATE Permission
Revoking Dbspace CREATE Permission
Authenticating a Login Account for a Managed Resource
Related reference
Dbspace Privilege Summary