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	Requires one of: DBA authority. SPACE ADMIN authority.
SAP Sybase IQ 16.0	Requires MANAGE ANY DBSPACE system privilege.

The SAP Sybase IQ resource is authenticated and running.

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

IQ_SYSTEM_MAIN and IQ_SHARED_TEMP dbspaces cannot be read-only.

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the left pane, select IQ Servers > Space Management > 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.
Click OK.