Changing a Dbspace to Read-Only

Change a dbspace to read-only mode.

Prerequisites

Database Version	Dbspace Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority SPACE ADMIN authority
SAP Sybase IQ 16.0	You must have the MANAGE ANY DBSPACE system privilege.

The SAP Sybase IQ resource is authenticated and running.
In a multiplex configuration, the coordinator node is running.

Task

You can add a new DB file to a read-only dbspace. Cache dbspaces are an exception; you cannot add a new DB file to a read-only cache 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. IQ_SYSTEM_MAIN and IQ_SHARED_TEMP dbspaces cannot be read-only.

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 SAP Sybase IQ server of the new file location.

In the Perspective Resources view, select the resource, and select Resource > Administration Console.
In the left pane, expand IQ Servers > Space Management, and then select Dbspaces.
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.
On the General page, click ReadOnly mode.
Set Status to Online or Offline.
Do one of:
- Click OK to update any changes to the database and exit the properties view.
- Click Apply to update any changes to the database, but remain in the properties view.
- Click Cancel to cancel any changes not updated to the database and exit the properties view.