Skip to Content
Author's profile photo Former Member

Error Upgrading SAP IQ 16.0 SP3 to SP8 with RLV Enabled

While upgrading a SAP IQ 16.0 SP3 database with some tables with RLV enable to SAP IQ SP8 I encounter and the error saying that the database could not be upgrade because the user “” was using the database.  Here I detail how I solved the issue.

While on SP3

1. Identify all the tables that enabled for RLV.

         SELECT b.table_id, b.table_nameFROM SYSIQTAB a,SYSTABLE bWHERE a.table_id = b.table_id and is_rlv=‘T’

I use the following procedure because “alter table mytable disable RLV STORE” make the database crash.

2. Create a backup table for every RLV enable table.

3. Copy each RLV enable tables to the corresponding new backup table.

          insert into orig_table select * from bck_table

4. Drop all the RLV enable tables.

5. Make the RLV dbspace read only.

          alter dbspace IQ_RLVStore readonly

6. Remove all the files from the RLV dbspace.

          alter dbspace IQ_RLVStore drop file RLV_F1

7. Drop the RLV dbspace

          drop dbspace IQ_RLVStore

8. Recreate all the RVL enable table that you dropped, but do not RLV enable them.

9. Restore the content of the tables from the backup tables.

10. Drop the backup tables.

On SP8

Now, you should be able to shut down the database on SP3, started on SP8 and upgrade it.

Do not forget to re enable RLV after the upgrade.

This post was first published on by personal web blog at Error Upgrading SAP IQ 16.0 SP3 to SP8 with RLV Enabled | ARBIME

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Roland Kramer
      Roland Kramer


      The following procedure worked for me after the upgrade from SP04.0x to SP08.0x

      Start the SP08.0x IQ in "Upgrade mode"

      start_iq @CIANLS.cfg CIANLS.db -iqro 1 -gm 1 -gd
      DBA -iqrvrec_bypass 1

      Run the I-SQL Interface with
      alter database upgrade;

      Stop the IQ database with

      Start the IQ database again (in normal mode) with


      start_iq @SAPNLSDB.cfg SAPNLSDB.db

      Start the IQ database

      The syb_rlv space was online and readwrite, despite what the check with the I-SQL Interface and the stored procedure said. The Information from the SAP Control Center (SCC) were correctly.

      Best Regards Roland

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks a lot!

      Author's profile photo John Appleby
      John Appleby

      Hey Roland,

      Useful information, where did you get this from? Don't see any guide to this online. Thanks!


      Author's profile photo Roland Kramer
      Roland Kramer


      I'm currently updateing the existing first Guidance Document to SP08, as there are new settings and features for IQ 1.6.0

      Best Regards


      Author's profile photo Saroj Bagai
      Saroj Bagai

      Do not run 'atter database upgade' with RLV  forced recovery steps.   After RLV have been recovered, restart server with -iqro 1 flag and using dbisql run alter database upgrade