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.0 no longer supports aliases for the shared IQ main store. DBAs must ensure that all files in all dbspaces in the shared store, namely all files in IQ_SYSTEM_MAIN and shared user dbspaces, are accessible in exactly the same way using the same file paths from all nodes. 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.
Accessing shared disks on UNIX or Linux
On UNIX or Linux, there are two ways to access shared disks.
Use absolute paths to shared stores. For example:
/dev/rdsk/c4t600A0B80005A7F5D0000024B49757E55d0s0 /dev/rdsk/c4t600A0B80005A7F5D0000024B49757E55d0s1 /dev/rdsk/c4t600A0B80005A7F5D0000024B49757E55d0s2
Use soft links to shared stores. For example:
store/mainstore/userdb1store/userdb2
where each of these soft links point to raw devices as shown in step 1.
Accessing shared disks on Windows
On Windows, there are two ways to access shared disks.
Use the Disk Physical number. For example:
\\\\.\\PhysicalDrive1 \\\\.\\PhysicalDrive2 \\\\.\\PhysicalDrive3
Use absolute paths using drive letters. For example:
x:\main y:\userdb1 z:\userdb2
Using the drive letters limits the number of disks to fewer than 26, so the first method is better.
