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.
Updates on the IQ_SHARED_TEMP store require the MANAGE ANY DBSPACE system privilege.
You cannot execute ALTER FILE RENAME PATH on the IQ_SHARED_TEMP dbspace.
You cannot execute ALTER DBSPACE ALTER FILE READONLY on the IQ_SHARED_TEMP dbspace.

Note: If you start the coordinator in single node mode with -iqro, adding or dropping a file returns the error SQL Anywhere Error -757: Modifications not permitted for read-only database.

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
Use ALTER DATABASE ADD FILE statement in Interactive SQL to add dbfiles to shared dbspaces.

Parent topic: Dbspace Updates in Multiplex

Updates on IQ_SHARED_TEMP