Dropping the RLV Dbspace

The RLV dbspace cannot be dropped unless it is empty. Dropping the RLV dbspace will mean that you can no longer create RLV-enabled tables, or alter existing tables to enable RLV storage.

Prerequisites

SAP Sybase IQ server has a simplex database.
A single RLV dbspace exists on the database.
The RLV dbspace is read-only.

Task

Unlike an IQ main store dbspace, you cannot relocate objects (transaction logs) resident on the RLV dbspace in order to empty it. Instead, in order to empty the RLV dbspace, you must ensure that there are no RLV-enabled table in the store.

Note: Dropping the RLV dbspace will mean that you can no longer create RLV-enabled tables, or modify existing tables to be RLV-enabled.

Check for RLV-enabled tables (for example, SYSIQTAB).
1. If RLV-enabled tables exist, disable RLV storage, or drop the tables.
```
SELECT table_id, table_name 
FROM SYSIQTAB 
WHERE table_id IN (SELECT table_id FROM SYSIQTAB WHERE is_rlv='T')
```
Alter the dbspace to be read-only, using the statement ALTER DBSPACE <dbspacename> READONLY.
```
ALTER DBSPACE d1 READONLY
```
Drop the dbspace using the command DROP DBSPACE <dbspacename>.
```
DROP DBSPACE d1
```