Upgrading databases to Version 12.6

You must upgrade all existing databases after installing Sybase IQ 12.6. Running ALTER DATABASE UPGRADE makes the databases compatible with the new version of Sybase IQ, and lets you take advantage of performance optimizations and enhancements. Upgrading carries out the following tasks:

• Adds new system tables.

• Adds new columns to system tables and updates existing system table columns.

• Makes several changes to multiplex system tables.

• Adds several database options, and changes defaults or ranges for others. Database options provide a degree of tuning for overall database behavior or for individual user behavior. The list of available options is kept in the system tables, and needs to be upgraded for the options to become available. Options removed from Sybase IQ 12.6 are not removed from existing databases.

• Adds and updates system stored procedures. Multiplex stored procedures, while documented in Sybase IQ Reference Manual, are intended for use by Sybase Central for managing the multiplex, or are used internally by IQ during multiplex operation.

Sybase strongly recommends that you perform a full backup of your databases before upgrading to version 12.6.

See the chapter “Migrating Data from Prior Versions” in your Sybase IQ Installation and Configuration Guide for other migration issues. See New Features in Sybase IQ 12.6 for more information on new system procedures, new options, and other new features and behavior changes.