Viewing or Modifying Dbspace Properties

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

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. 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 modifying properties, clicking Apply before changing screens is not necessary, but will save any changes.
   • If you do not have privileges to modify properties, Sybase 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 – Enables (On) or disables (Off) disk striping for this dbspace. Stripe size – The number of kilobytes (KB) to write to each file before the disk-striping algorithm moves to the next stripe for this dbspace. File – (for Catalog type only) Reallocate Space – (for 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.
   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. Click OK.