Skip to content

Error Upgrading SAP IQ 16.0 SP3 to SP8 with RLV Enabled

June 5, 2014

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_name
    WHERE a.table_id = b.table_id and is_rlv=‘T’

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

  1. Create a backup table for every RLV enable table.
  2. Copy each RLV enable tables to the corresponding new backup table.insert into orig_table
    select * from bck_table
  3. Drop all the RLV enable tables.
  4. Make the RLV dbspace read only.alter dbspace IQ_RLVStore readonly
  5. Remove all the files from the RLV dbspace.alter dbspace IQ_RLVStore drop file RLV_F1
  6. Drop the RLV dbspacedrop dbspace IQ_RLVStore
  7. Recreate all the RVL enable table that you dropped, but do not RLV enable them.
  8. Restore the content of the tables from the backup tables.
  9. 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.


From → SAP IQ

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: