Altering the RLV Store Dbspace to Read-only

You can use the ALTER DBSPACE statement to set the RLV store to read-only. However, the RLV store is, by definition, a read-write store. Therefore only make the dbspace read-only if necessary (as in the case of dropping the dbspace).

Prerequisites

SAP Sybase IQ server has a simplex database.
A single RLV store dbspace exists on the database.

Task

Alter the dbspace to be read-only, using the statement ALTER DBSPACE <dbspacename> READONLY.

ALTER DBSPACE d1 READONLY