Empty a DB file and move the objects in the file to another available
read-write DB file. Not applicable to cache dbspace DB files.
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.
- The DB file should be read-only.
Task- In the Perspective Resources view, select the resource, and
select .
- In the left pane, expand , and then select DB Files.
- Select a DB file from the right pane and either:
- Click the arrow to the right of the name and select Empty
File, or
- From the Administration Console menu bar, select .
Note: You cannot empty a db file belonging to the RLV store dbspace.
- Click Yes.
Objects in the DB file are moved to another read-write DB file in the same dbspace.