Deleting a DB File

Delete a DB file from a dbspace. With the exception of the IQ_SHARED_TEMP dbspace, you cannot delete the last DB file in a dbspace.

Prerequisites

Database Version	DB File 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.
The dbspace must be in read-write mode, except for the RLV store dbspace, which can be in either mode.
The DB file must be empty.
The last DB file in a dbspace cannot be deleted, except for IQ_SHARED_TEMP. The first file that is made Read-Write in IQ_SHARED_TEMP must be the last file dropped.
- Dropping files in IQ_SHARED_TEMP in a multiplex is supported. In IQ_SHARED_TEMP, the last DB file can only be deleted on the coordinator once it is started in a single-node mode.
  Note: Ensure SAP Control Center is not running when you start the coordinator in single node mode. If SAP Control Center is running, you will be unable to manage a multiplex after starting the coordinator in single node mode.
- Dropping files in IQ_SHARED_TEMP in simplex is also supported.

Task

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 DB Files.
Select one or more DB files from the right pane and either:
- Click the arrow to the right of the name and select Delete, or
- From the Administration Console menu bar, select Resource > Delete.
Tip: Use Shift-click or Control-click to select multiple dbfiles.
Click Yes to confirm deletion.