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 the file status for all shared files to the coordinator. SAP 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 cannot participate in any DQP operations. Use sp_iqmpxfilestatus to diagnose distributed file problems.