Preparing for a Database Upgrade

Perform these tasks before upgrading a database to version 16.0.

1. Disconnect all users from the server.
2. Back up the SAP Sybase IQ 15 database.
3. From the database, drop:

   • All JOIN and LD indexes

   • (Multiplex users) Logical servers named AUTO, COORDINATOR, ALL or DEFAULT

   If you do not drop these objects, ALTER DATABASE UPGRADE fails. To recover, open the database with the SAP Sybase IQ 15.x binary and drop all join indexes and the named logical servers.

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 upgrade 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.