Updates on IQ_SHARED

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.
Note: Never enter ALTER DBSPACE DROP FILE when connected using -iqro. If you start the server with -iqro, adding or dropping files returns the error Modifications not permitted for read-only database.
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.
Adding Dbfiles to Shared Dbspaces
Perform these steps in Interactive SQL or Sybase Central.

Parent topic: Dbspace Updates in Multiplex

Updates on IQ_SHARED_TEMP