Database Upgrades

Important information about database upgrades.

For detailed information about installing and upgrading SAP Sybase IQ, see the Installation and Configuration Guide.
CR# Description
750748
  • Shut down all products that use $SYBASE before upgrade – The SYBASE variable identifies the location of the common parent directory shared by SAP Sybase applications like SAP Adaptive Server Enterprise and Sybase Open Client.
    Failure to shut down all products that use $SYBASE may generate signal 11 (SIGSEGV) errors when you upgrade SAP Sybase IQ.
  • Workaround – Shut down all SAP Sybase applications, restart the SAP Sybase IQ server, and retry the upgrade.
702052
  • Drop all JOIN and all LD indexes. On multiplex, drop all logical servers named AUTO, COORDINATOR, ALL or DEFAULT – If you do not drop these objects and try to run an ALTER DATABASE UPGRADE in SAP Sybase IQ 16.0, the upgrade fails and the server returns a message that indicates that a database upgrade is not possible when these objects are in use.
  • Recovery Information – To recover from a failed upgrade, shut down the 16.0 server, open the database with SAP Sybase IQ 15.x, and drop all LD and all JOIN indexes as well as any named logical servers before proceeding with the migration.
Parent topic: Installation and Upgrade