Upgrading a Sybase IQ 12.6/12.7 Database

Upgrading from Sybase IQ 12.6/12.7 database is very different than upgrading from a Sybase IQ 15 database. This upgrade involves an unload/reload of the catalog. Follow this task flow to migrate a 12.6/12.7 database to Sybase IQ 15.4.

Read the Sybase IQ release bulletin for the latest information. See the special installation instructions section in the release bulletin for any installation instructions not included in this document.
Upgrade to Sybase IQ 12.7 ESD #5. All migration paths assume that you are migrating from Sybase IQ 12.7 ESD #5 as a minimum.
The SORTKEY function uses the International Components for Unicode (ICU) library, instead of the Sybase Unicode Infrastructure Library (Unilib^®). Sort-key values created using a version earlier than 15.0 do not contain the same values created using version 15.0 and later. Regenerate any sort-key values in your database that were generated using a version of Sybase IQ earlier than 15.
Sybase IQ 15 no longer supports creating custom collations. If you are rebuilding a database with a custom collation, the collation is preserved if you rebuild in a single step. If you unload the database, then load the schema and data into a database that you create, then you must use one of the supplied collations.
Back up your current installation and save copies of any changes you made to default login and post-login scripts. Create your backups on removable media, like tape, DVD, or CD. Make sure the backups are readable before you proceed.
To effectively plan your migration, review and understand the database migration utilities. Sybase IQ 15 includes an iqunload utility that you can use to re-create the schema for your database or simply migrate your database from 12.x to 15. An iqlsunload utility is available for 12.7 multiplex users who need to move local stores.
Resolve potential migration errors before you migrate. Sybase IQ 15 no longer supports some 12.x features and objects. Update these objects before you begin for the migration utilities to function correctly.
Follow the work flows for the migration you want to perform. There are separate migration paths for simplex and multiplex databases.

Database File Migration
Upgrading from Sybase IQ 12.6/12.7 to Sybase IQ 15.4 requires database file migration instead of a simple database upgrade. Sybase IQ 15.4 includes tools to ensure a smooth and error-free migration.
Understanding iqunload
iqunload is a fully automated migration tool that recreates the catalog store and reloads it with the existing database schema metadata. Only the catalog is recreated; the data and temp dbspaces are not changed.
Sybase IQ12.7 Local Store Utility
In Sybase IQ 15.4 multiplex configurations, multiple nodes can write to the main store, which eliminates the need for local stores. iqlsunload is a migration tool that you can use to unload an Sybase IQ12.7 local store.
Avoiding Potential Migration Problems
Sybase IQ 15.4 no longer supports some Sybase IQ 12.7/12.6 features and objects. To avoid potential problems, correct these items before you migrate your database.
Migrating Simplex Databases
Perform all of the steps in this task flow to migrate a Sybase IQ 12.7/12.6 database simplex database to Sybase IQ 15.4.
Migrating Multiplex Databases
Follow this workflow to migrate multiplex databases. Review the task summary and perform all steps in sequence.
Postmigration Tasks
Check this list after you migrate you database.

Parent topic: Database Upgrades