Accessing the shared disk array

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.

StepsAccessing shared disks on UNIX or Linux

On UNIX or Linux, there are two ways to access shared disks.

  1. Use absolute paths to shared stores. For example:

    /dev/rdsk/c4t600A0B80005A7F5D0000024B49757E55d0s0
    /dev/rdsk/c4t600A0B80005A7F5D0000024B49757E55d0s1
    /dev/rdsk/c4t600A0B80005A7F5D0000024B49757E55d0s2
    
  2. 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.

StepsAccessing shared disks on Windows

On Windows, there are two ways to access shared disks.

  1. Use the Disk Physical number. For example:

    \\\\.\\PhysicalDrive1
    \\\\.\\PhysicalDrive2
    \\\\.\\PhysicalDrive3
    
  2. 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.