Upgrading SAP Sybase IQ Databases to 16.0 SP03

Upgrade your database to SAP Sybase IQ 16.0 SP03 before you perform database read-write operations.

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 multiplex. 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.
   The 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.