Pre-Upgrade Tasks

After you install Sybase IQ, perform these steps before you upgrade your existing Sybase IQ database to version 15.3.

An issue affects any partition defined on a DATE column that contains a time portion. Before you upgrade databases that contain such partitions:
1. Use ALTER TABLE MERGE to combine the partition with the next partition.
2. Use ALTER TABLE SPLIT to divide the resulting partition into a definition with the same criteria, but no time portion.
Drop and recreate all Sybase IQ 15.2 GA TEXT indexes that have not already been dropped and recreated as part of a version 15.2 ESD upgrade. TEXT indexes created in Sybase IQ 15.2 GA are not compatible with later versions of Sybase IQ.