Allowed Dbspace Transformations

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.

Allowed Dbspace Configuration Transformations
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

Note:

Dynamically offline means the dbspace is marked offline in memory, as opposed to marked offline in the catalog.
A read-only (RO) IQ_SYSTEM_MAIN dbfile can be dynamically offline.
For IQ_SYSTEM_MSG, the only modification that is permitted is to rename the path, which is done using the command ALTER DBSPACE IQ_SYSTEM_MSG RENAME 'filepath'.