Remove direct-attached storage from the cache dbspace
by dropping files or raw devices.
Prerequisites
- A cache dbspace on the simplex or multiplex node.
- Requires MANAGE ANY DBSPACE system privilege.
Task
You can drop dbfiles from a cache dbspace even if the dbspace is read-write.
- Connect to the simplex or multiplex node.
- Remove a single file or raw device using the ALTER DBSPACE statement:
ALTER DBSPACE myDAS DROP FILE iqdas2
Note: Multiple DROP FILE clauses are not allowed.