Changing a Dbspace to Read-Only

Change a dbspace to read-only mode.

Prerequisites
Space Admin authority is required.
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 location 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, highlight the resource and select Resource > Administration Console.
  2. In the left pane of the Administration Console view, select IQ Servers > Space Management > Dbspaces.
  3. In the Dbspaces view, highlight the dbspace to modify.
  4. Hover the mouse pointer over the dbspace and click the arrow.
  5. Select Properties.
  6. In the General view, click ReadOnly mode.
  7. Click Status Online or Offline.
  8. Click OK.
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