Simplex Upgrade

Follow these steps to upgrade a simplex database from 15.x to 15.4.

1. Disconnect all users from the server.
2. Back up the database with the version of Sybase IQ you currently use.
3. Shut down the server.
   If the server aborts or hangs during shutdown, stop and do not proceed to the next step. Instead restart the database with the version you are currently using and shut down the server. Proceed to the next step only on a clean shutdown.
4. Use Sybase IQ 15.4 to restart the server with these startup flags: -gm 1 and -iqro 1
   The -gm switch controls the number of connections. If SCC is running, use -gm 2 or the upgrade may fail.
5. Start Interactive SQL and connect to the database.
6. Use an ALTER DATABASE UPGRADE statement to upgrade the database.
   See Reference: Statements and Options > SQL Statements > ALTER DATABASE statement for more information.
7. Run sp_iqcheckdb ('allocation database') and verify that there are no errors.
8. Shut down and restart the server normally (without the -gm 1 and -iqro 1 startup flags).
9. Back up the database.