Preparing for a Database Upgrade

Perform these tasks before upgrading a 15.x database to version 16.0.

1. Disconnect all users from the server.
2. Back up the SAP Sybase IQ 15.x database.
3. From the database, 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.

   To recover, shutdown the 16.0 server, open the database the 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.

4. Update DATE columns that contain a time portion.
   There is a known issue that affects any partition defined on a DATE column that contains a time portion:.

   • Use ALTER TABLE MERGE to combine the partition with the next partition.
   • Use ALTER TABLE SPLIT to divide the resulting partition into a definition with the same criteria, but no time portion.
5. Drop and re-create all SAP Sybase IQ 15.2 TEXT indexes that have not already been dropped and recreated as part of a version 15.2 ESD upgrade.

   TEXT indexes created in SAP Sybase IQ 15.2 are incompatible with later versions of SAP Sybase IQ.

6. On database upgrades, using the ALTER DATABASE UPGRADE statement, privileged system procedures are dropped and re-created. As part of this process, any explicit EXECUTE privilege granted on system procedures is lost and must be manually regranted post upgrade.