SAP Sybase IQ
16.0
SP03 includes changes to the system tables and database schema. If
you are migrating a SAP Sybase IQ 15.x database, objects no longer
supported by SAP Sybase IQ
16.0 must be removed or modified.
Note: All steps are specific to customers who are upgrading from
SAP Sybase IQ 15.x. Customers upgrading from
SAP Sybase IQ
16.0 or later can skip these steps.
- Disconnect all users from the 15.x server.
- Drop all JOIN and all LD indexes
from the 15.x database.
- 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.
- Drop and re-create all SAP Sybase IQ 15.2 TEXT indexes
that have not already been dropped and re-created 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.
- Shut down the SAP Sybase IQ
15.x server or multiplex.
If the server stops responding during shutdown, do not proceed to
the next step. Restart the database and shut it down again. Proceed to the next task
only on a clean shutdown.