Restore of raw device with link pathname fails [CR 563004]

If the first IQ_SYSTEM_MAIN dbfile and the first IQ_SYSTEM_TEMP dbfile are raw devices and the pathname in Sybase IQ is a link, then the restore fails to open the raw devices. Instead, RESTORE creates file system files that are the size of the raw devices and restores to these files. When the database is started after the restore, however, the correct paths that point to the raw devices are used.

Raw devices for user dbfiles are restored correctly.

The workaround is to create additional links that point to the raw devices, using the names of the file system files created by RESTORE. After the restore completes, you can delete the extra links.

For example, given the following database:

create database 'testdb'
java off jconnect off
iq path '../lnk_5a'
temporary path '../lnk_5d'

where

lnk_5a -> /sys/rdsk/c4t600A0B80005A7F5D00024
lnk_5d -> /sys/rdsk/c4t600A0B80005A7F5D00025

RESTORE fails to open lnk_5a and lnk_5d. Instead, RESTORE creates the file system files lnk_5a.iq and lnk_5d.iqtmp that are the size of the raw devices and restores to these files.

For the workaround, you can create additional links named lnk_5a.iq and lnk_5d.iqtmp that point to the raw devices. Then the restore is successful. You can delete the extra links after the restore completes.