sp_iqmpxfilestatus procedure

When executed on the coordinator node, displays file status for every shared dbfile on every included secondary node.

Shared dbfiles include all files in IQ_SYSTEM_MAIN, IQ_SHARED_TEMP, and user dbspaces. When executed on a secondary node, displays file status for only the current node. Users must be licensed for the Multiplex Grid Option to run secondary nodes. For complete information, including syntax, see Using Sybase IQ Multiplex.