You can use the ALTER DBSPACE statement to configure the RLV dbspace. The statement usage may differ from other dbspaces.
RLV Dbspace State | ALTER Type | Permitted for RLV Dbspace |
---|---|---|
Online | ALTER DBSPACE OFFLINE | Yes, if the dbspace is read-only |
ALTER DBSPACE ONLINE | No | |
ALTER DBSPACE READONLY | Yes, if the dbspace is read-write and no RLV-enabled objects exist | |
ALTER DBSPACE READWRITE | Yes, if the dbspace is read-only | |
ALTER STRIPING or STRIPESIZEKB | No | |
RENAME DBSPACE | Yes | |
ADD FILE | Yes | |
DROP FILE | Yes, if the file is not in use | |
ALTER FILE READONLY | No | |
ALTER FILE READWRITE | No | |
ALTER FILE SIZE | Yes, if the dbspace is read-write | |
ALTER FILE RENAME LOGICAL NAME | Yes | |
ALTER FILE RENAME PATH | No | |
Offline | ALTER DBSPACE OFFLINE | No |
ALTER DBSPACE ONLINE | Yes | |
ALTER DBSPACE READONLY | No | |
ALTER DBSPACE READWRITE | No | |
ALTER STRIPING or STRIPESIZEKB | No | |
RENAME DBSPACE | Yes | |
ADD FILE | No | |
DROP FILE | Yes. File is, by definition, empty | |
ALTER FILE READONLY | No | |
ALTER FILE READWRITE | No | |
ALTER FILE SIZE | No | |
ALTER FILE RENAME LOGICAL NAME | Yes | |
ALTER FILE RENAME PATH | Yes | |
Read-only | ALTER DBSPACE OFFLINE | Yes |
ALTER DBSPACE ONLINE | Yes | |
ALTER DBSPACE READONLY | No | |
ALTER DBSPACE READWRITE | Yes | |
ALTER STRIPING or STRIPESIZEKB | No | |
RENAME DBSPACE | Yes | |
ADD FILE | Yes | |
DROP FILE | Yes | |
ALTER FILE READONLY | No | |
ALTER FILE READWRITE | No | |
ALTER FILE SIZE | No | |
ALTER FILE RENAME LOGICAL NAME | Yes | |
ALTER FILE RENAME PATH | No | |
Read-write | ALTER DBSPACE OFFLINE | No |
ALTER DBSPACE ONLINE | No | |
ALTER DBSPACE READONLY | Yes, if no RLV-enabled objects exist | |
ALTER DBSPACE READWRITE | No | |
ALTER STRIPING or STRIPESIZEKB | No | |
RENAME DBSPACE | Yes, if no RLV-enabled objects exist | |
ADD FILE | Yes, if no RLV-enabled objects exist | |
DROP FILE | Yes, if the file is not in use | |
ALTER FILE READONLY | No | |
ALTER FILE READWRITE | No | |
ALTER FILE SIZE | Yes, but when decreasing file size, truncated space must be empty | |
ALTER FILE RENAME LOGICAL NAME | Yes | |
ALTER FILE RENAME PATH | No |