Upgrading SAP Sybase IQ 15 Databases

Perform these steps to upgrade SAP Sybase IQ 15 simplex and multiplex databases to SAP Sybase IQ 16.0.

1. Do one of the following:

   Server	Action
   Simplex	Shut down the server.
   Multiplex	Shut down all multiplex nodes.

   Note: If the server stops responding during shutdown, do not proceed to the next step. Restart the database with SAP Sybase IQ 15 and shut down the server. Proceed to the next step only on a clean shutdown.
2. Do one of the following:

   Sever	Action
   Simplex	Start the SAP Sybase IQ 16.0 server using the -gm 1 and -iqro 1 startup flags.
   Multiplex	Use SAP Sybase IQ 16.0 to restart the coordinator using the -iqmpx_sn 1, -gm 1, and -iqro 1 startup flags.

   The -gm switch controls the number of connections. If Sybase Control Center is running, use -gm 2 or the upgrade may fail.

3. Start Interactive SQL and connect to the database.
4. Do one of the following to upgrade the database:

   System Procedure Security Model	SQL Syntax
   Combination model (default)	ALTER DATABASE UPGRADE
   SYSTEM PROCEDURE INVOKER model only	ALTER DATABASE UPGRADE SYSTEM PROCEDURE AS DEFINER OFF

5. Run sp_iqcheckdb ('allocation database') to verify that there are no errors.
6. Do one of the following:

   Server	Action
   Simplex	Shut down and restart the server normally (without the -gm 1 and -iqro 1 startup flags).
   Multiplex	Shut down and restart the coordinator normally (without the -iqmpx_sn 1, -gm 1, and -iqro 1 startup flags). Synchronize and restart all multiplex secondary servers.

7. Back up the database.