Run the ALTER DATABASE UPGRADE command against every existing Sybase IQ database to upgrade it to IQ 12.7. 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.7 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.7.
Upgrading databases to
version 12.7
Performance optimizations in Version 12.7 depend on structural changes and option settings made by the ALTER DATABASE UPGRADE command. The format of the database files is the same as in Sybase IQ Version 12.6, 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).
Be sure to start the server in a way that restricts user connections. Never allow other users to connect when ALTER DATABASE UPGRADE is running. Sybase recommends using two server start-up options:
Use -gd DBA so that only users with DBA authority can start and stop databases.
Use -gm 1 to allow a single connection plus one DBA connection above the limit so that a DBA can connect and drop others in an emergency.
An alternate way to restrict connections is to specify
sa_server_option('disable_connections', 'ON')
just after you start the connection where you are performing the upgrade and
sa_server_option('disable_connections', 'OFF')
on the same connection after upgrading. The disadvantage is that this method precludes emergency access from another DBA connection.
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.
