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 |