Changing a Dbspace to Read-Only

Change a dbspace to read-only mode.

Prerequisites
Authenticate with Sybase IQ using an account that has DBA or Space Admin authority.
Task

You can add a new DB file to a read-only dbspace. You cannot delete a DB file from a read-only dbspace.

You can change paths of DB files in a read-only offline dbspace.
Note: Changing the file path here does not move the file to the new location. If a file is moved, changing the path here only informs the Sybase IQ server of the new file location.

IQ_SYSTEM_MAIN and IQ_SHARED_TEMP dbspaces cannot be read-only.

  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 to modify.
  4. Click the drop-down arrow that appears next to the dbspace name and select Properties.
  5. On the General page of the properties dialog, click ReadOnly mode.
  6. Click Status Online or Offline.
  7. Click Apply to save your changes and keep editing, or click OK to save and close the properties dialog.
Parent topic: Manage a Dbspace
Related tasks
Viewing Dbspace Properties
Adding a Dbspace
Modifying a Dbspace
Preallocating Space for a Dbspace
Deleting a Dbspace
Generating Dbspace DDL Commands