Change the name, mode, status, and striping properties of a dbspace.
Prerequisites
Authenticate with Sybase IQ using an account that has DBA or Space Admin authority.Task
You cannot change a dbspace’s name if it is a system dbspace (with a name beginning with IQ_SYSTEM) or a system catalog dbspace.
- In the Perspective Resources view, select the resource and select .
- In the left pane of the Administration Console, expand and select Dbspaces.
- In the right pane, select a dbspace to modify.
- Click the drop-down arrow that appears next to the dbspace name and select Properties.
- On the General page of the properties dialog, specify:
| Option |
Description |
|---|
Name
|
Name of the dbspace.
|
Type
|
(Not editable) The dbspace type.
|
Mode
|
(Optional) Mode of the dbspace:
|
Status
|
(Optional) Status of the dbspace:
|
Striping
|
(Optional) 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.
|
- Click Apply to save your changes and keep editing, or click OK to save and close the properties dialog.