Your ability to change a dbspace configuration depends on the type of alter operation and certain attributes of the dbspace. Alter operations are governed by the state of the dbspace (online or offline), the read-write status of the dbspace, and the type of dbspace.
State | Alter Type | Allowed for User Main | Allowed for IQ_SHARED_TEMP, IQ_SYSTEM_MAIN, or IQ_SYSTEM_TEMP |
---|---|---|---|
Online dbspace | |||
ALTER DBSPACE OFFLINE | Yes, if RO | No | |
ALTER DBSPACE ONLINE | No | Yes for IQ_SYSTEM_MAIN, No for IQ_SHARED_TEMP and IQ_SYSTEM_TEMP | |
ALTER DBSPACE READONLY | Yes, if it is RW | No | |
ALTER DBSPACE READWRITE | Yes, if it is RO | No | |
ALTER STRIPING or STRIPESIZEKB | Yes | Yes on simplex and on multiplex coordinator | |
RENAME DBSPACE | Yes | No | |
ADD FILE | Yes | Yes | |
DROP FILE | Yes, if empty and RO | Yes, if empty and RO. Dropping files in IQ_SHARED_TEMP requires that this operation be done only on the coordinator once it is started in a single-node mode. Dropping files in IQ_SHARED_TEMP in simplex is also supported. The first file that is made RW in IQ_SHARED_TEMP must be the last file to be dropped. | |
ALTER FILE READONLY | Yes, if RW | Yes, if RW and not the last RW dbfile. Making files in IQ_SHARED_TEMP read-only is not allowed. | |
ALTER FILE READWRITE | Yes, if RO | Yes, if RO | |
ALTER FILE SIZE | Yes, if RW dbspace and dbfile | Yes, if RW | |
ALTER FILE RENAME LOGICAL NAME | Yes | Yes | |
ALTER FILE RENAME PATH | No | Yes for IQ_SHARED_TEMP and IQ_SYSTEM_TEMP; takes effect when database restarts. No for IQ_SYSTEM_MAIN. | |
Offline dbspace | |||
ALTER DBSPACE OFFLINE | No | N/A | |
ALTER DBSPACE ONLINE | Yes | N/A | |
ALTER DBSPACE READONLY | No | N/A | |
ALTER DBSPACE READWRITE | No | N/A | |
ALTER STRIPING or STRIPESIZEKB | Yes | N/A | |
RENAME DBSPACE | Yes | N/A | |
ADD FILE | No | N/A | |
DROP FILE | Yes, if empty | N/A | |
ALTER FILE RO | Yes | N/A | |
ALTER FILE RW | Yes | N/A | |
ALTER FILE SIZE | No | N/A | |
ALTER FILE RENAME LOGICAL NAME | Yes | N/A | |
ALTER FILE RENAME PATH | Yes | N/A | |
Dynamically offline dbspace | |||
ALTER DBSPACE OFFLINE | Yes, if RO | N/A | |
ALTER DBSPACE ONLINE | Yes | N/A for IQ_SYSTEM_MAIN and IQ_SYSTEM_TEMP, Yes for IQ_SHARED_TEMP | |
ALTER DBSPACE READONLY | Yes, if RW | N/A | |
ALTER DBSPACE READWRITE | No | N/A | |
ALTER STRIPING or STRIPESIZEKB | Yes | N/A | |
RENAME DBSPACE | Yes | N/A | |
ADD FILE | No | N/A | |
DROP FILE | Yes, if empty | N/A | |
ALTER FILE READONLY | No | N/A | |
ALTER FILE READWRITE | No | N/A | |
ALTER FILE SIZE | No | N/A | |
ALTER FILE RENAME LOGICAL NAME | Yes | N/A | |
ALTER FILE RENAME PATH | No | N/A | |
Read-only dbspace | |||
ALTER DBSPACE OFFLINE | Yes, if online | N/A | |
ALTER DBSPACE ONLINE | Yes, if offline | N/A | |
ALTER DBSPACE READONLY | No | N/A | |
ALTER DBSPACE READWRITE | Yes, if online | N/A | |
ALTER STRIPING and STRIPESIZEKB | Yes | N/A | |
RENAME DBSPACE | Yes | N/A | |
ADD FILE | Yes | N/A | |
DROP FILE | Yes, if empty | N/A | |
ALTER FILE READONLY | Yes, if RW | N/A | |
ALTER FILE READWRITE | Yes, if RO | N/A | |
ALTER FILE SIZE | No | N/A | |
ALTER FILE RENAME LOGICAL NAME | Yes | N/A | |
ALTER FILE RENAME PATH | Yes, if offline | N/A | |
Read-write dbspace | |||
ALTER DBSPACE OFFLINE | No | No | |
ALTER DBSPACE ONLINE | Yes, if dynamically offline | No for IQ_SYSTEM_MAIN and IQ_SYSTEM_TEMP, Yes if dynamically offline for IQ_SHARED_TEMP | |
ALTER DBSPACE READONLY | Yes | No | |
ALTER DBSPACE READWRITE | No | No | |
ALTER STRIPING and STRIPESIZEKB | Yes | Yes | |
RENAME DBSPACE | Yes | No | |
ADD FILE | Yes | Yes | |
DROP FILE | Yes, if empty | Yes, if empty and RO. Dropping files in IQ_SHARED_TEMP requires that this operation be done only on the coordinator once it is started in a single-node mode. Dropping files in IQ_SHARED_TEMP in simplex is also supported. The first file that is made RW in IQ_SHARED_TEMP must be the last file dropped. | |
ALTER FILE READONLY | Yes, if RW | Yes, if RW. Making files in IQ_SHARED_TEMP readonly is not allowed. | |
ALTER FILE READWRITE | Yes, if RO | Yes, if RO | |
ALTER FILE SIZE | Yes, if RW | Yes, if RW | |
ALTER FILE RENAME LOGICAL NAME | Yes | Yes | |
ALTER FILE RENAME PATH | No | Yes, takes effect when database restarts | |
Read-only file | |||
ALTER FILE READONLY | No | No | |
ALTER FILE READWRITE | Yes | Yes | |
ALTER FILE SIZE | No | No | |
ALTER FILE RENAME LOGICAL NAME | Yes | Yes | |
ALTER FILE RENAME PATH | Yes, if offline | Yes, takes effect when database restarts | |
Read-write file | |||
ALTER FILE READONLY | Yes | Yes | |
ALTER FILE READWRITE | No | No | |
ALTER FILE SIZE | Yes, if dbspace is RW and ONLINE | Yes | |
ALTER FILE RENAME LOGICAL NAME | Yes | Yes | |
ALTER FILE RENAME PATH | No | Yes, takes effect when database restarts |