Before you perform database read-write operations, upgrade your 15.x or
16.x database to SAP Sybase IQ
16.0
SP03.
- 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.
- Start Interactive SQL and connect to the database.
- 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.
- Run sp_iqcheckdb
( 'allocation database' ) to verify that there are no
errors.
- 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.
|
- Back up the database.