Run the ALTER DATABASE UPGRADE command against every existing Sybase IQ database to upgrade it to IQ 12.6. This makes the databases compatible with the new version of Sybase IQ.
Upgrading a database adds and modifies system tables, system procedures, and options to enable 12.6 options. It does not change the file format used to store and access data on a disk. It also does not remove preexisting options that have been eliminated in version 12.6.
To upgrade databases to
Version 12.6:
Performance optimizations in Version 12.6 depend on structural changes and option settings made by the ALTER DATABASE UPGRADE statement. The format of the database files is the same as in Sybase IQ Version 12.4.3 or 12.5, but some system tables, stored procedures, and database options have changed.
To upgrade, follow these steps:
Make sure that you have performed the preceding steps in this chapter and installed any available EBFs. For details, see “Finding the latest information on EBFs and software maintenance”.
Disconnect from the database and reconnect to your database (again using an account with DBA privileges). This must be the only connection to the database.
Start DBISQLC or DBISQL and execute the ALTER DATABASE UPGRADE statement. For example:
ALTER DATABASE UPGRADE
If the database you are upgrading was created with the Java options set off, append the keywords JAVA OFF JCONNECT OFF to the preceding command.
The defaults for MAIN_RESERVED_DBSPACE_MB
and TEMP_RESERVED_DBSPACE_MB were increased
in version 12.5 for newly created databases. If these options are
set to less than the 200MB in your database, set the options to
200MB or 50% of the size of the last dbspace before or
immediately after upgrading your database.
