Files on Shared Disk Arrays

Sybase IQ multiplex functionality requires using the same file paths to access files in dbspaces in the shared stores from all nodes.

All files in all dbspaces in the shared store, namely all files in IQ_SYSTEM_MAIN and shared dbspaces, must be accessible in exactly the same way from all nodes. Files in the shared temporary store should be accessible from all nodes in the multiplex.

In Sybase IQ 12.7, every node in the multiplex had its own database path, called an alias, to use when opening files in the shared IQ main store, temp store and .iqmsg file.

Sybase IQ 15.3 no longer supports aliases for shared IQ stores. For IQ_SYSTEM_TEMP and IQ_SYSTEM_MSG, independent files are maintained for each node. The paths for these files must be accessible on the node that owns them.