Updating the RAPStore Database

Update the RAPStore Database.

Prerequisites The migration installation is complete, the RAPStore database is successfully installed on the machine, and the RAPStore is shut down.

To update the RAPStore Database:

  1. Source <RAP_R3_Install>/RAPStore/IQ-15_1/IQ-15_1.sh.
  2. Upgrade the database by issuing the command iqunload -au -v -c "uid=DBA;pwd=SQL;dbf=<RAP_R2_Install>/RAPStore/RAPDB/RAPSTORE.db; eng=RAPSTORE" -ms_filename <RAP_R2_Install>/RAPStore/RAPDB/RAPSTORE_main_store.iq. You may see some warnings during this process.
  3. Change to the directory <RAP_R2_Install>/RAPStore/RAPDB.
  4. Start the RAPStore Server. Execute start_iq @RAPSTORE.cfg RAPSTORE.db
  5. Log in to your RAPStore server (dbisql or isql).
  6. Run select @@version to verify that the database is now the updated version.


Created October 8, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com