Upgrading an SAP Sybase IQ Database Using Interactive SQL

Before you perform database read-write operations, upgrade your 15.x or 16.x database to SAP Sybase IQ 16.0 SP03.

1. For:

   Server	Action
   Simplex	Start the SAP Sybase IQ 16.0 SP03 server. Use the -gm 1 and -iqro 1 startup flags.
   Multiplex	Start the coordinator on the SAP Sybase IQ 16.0 SP03 multiple. Use the -iqmpx_sn 1, -gm 1, and -iqro 1 startup flags.

   The -gm switch controls the number of concurrent connections.

2. Start Interactive SQL and connect to the database.
3. Upgrade the database:
   ALTER DATABASE UPGRADE instantiates all SAP Sybase IQ 16.0 SP03 binaries and schema changes. To roll back to a previous version, you must restore from backup.
4. Run sp_iqcheckdb ( 'allocation database' ) to verify that there are no errors.
5. For:

   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.

6. Back up the database.