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 IQ12.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 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.

Related reference
UNIX or Linux Shared Array Path Definitions
Windows Shared Disk Array Path Definitions