When opening databases and executing certain commands, multiplex nodes maintain a file status for each shared dbspace file.
The coordinator maintains status data for all nodes, and each secondary node maintains its own file status data.
All included servers must return valid read-write status for a new IQ_SHARED_TEMP file, or the statement returns an error. If all nodes can access the newly added file, they return a Valid status message. All secondary servers return file status for all shared files to the coordinator. Sybase IQ maintains shared file status information for dbfiles of all shared dbspaces, but uses the information only in dbspace update commands that target the IQ_SHARED_TEMP dbspace.
If a secondary node does not have write access to one or more files in IQ_SHARED_TEMP, that node will not be eligible for participating in any DQP operations. Diagnose distributed file problems using sp_iqmpxfilestatus.