When you update IQ_SHARED_TEMP dbspaces, certain restrictions apply.
These rules affect IQ_SHARED_TEMP dbspace updates:
Only the coordinator can manipulate
shared IQ dbspaces.
Start the coordinator in single-node mode before dropping files from IQ_SHARED_TEMP. The first file made read-write in IQ_SHARED_TEMP must be the last file dropped. You may also drop files in IQ_SHARED_TEMP in simplex.
Updates on the IQ_SHARED_TEMP store require SPACE ADMIN authority.
ALTER FILE RENAME PATH is not allowed for the IQ_SHARED_TEMP
dbspace.
ALTER DBSPACE ALTER FILE READONLY is not allowed for the IQ_SHARED_TEMP
dbspace.
Shared File Status Data
When opening databases and executing certain commands, multiplex nodes maintain a file status for each shared dbspace file.