Viewing Dbspace Properties

Display the properties for the selected dbspace.

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. In the right pane, select a dbspace.
  4. Click the drop-down arrow that appears next to the dbspace name and select Properties.
Property Name Description

Name

Name of the dbspace.

Type

The dbspace type.

Mode

Mode of the dbspace:
  • ReadWrite
  • ReadOnly

Status

Status of the dbspace:
  • Online
  • Offline

Striping

Disk striping is enabled (On) or disabled (Off) 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.

Related tasks
Adding a Dbspace
Modifying a Dbspace
Changing a Dbspace to Read-Only
Preallocating Space for a Dbspace
Deleting a Dbspace
Generating Dbspace DDL Commands