This topic has been locked.
3 replies Latest Post - 2011-06-29T16:38:04Z by JP_Parkin
Pinned topic Migrating Infosphere Warehouse from 9.5.2 to 9.7.3
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
I'm tring to install Infosphere warehouse 9.7.3 migrating from Infosphere Warehouse 9.5.2 (on the same machine). I want to install it using the same profile of websphere application server and the same copy of DB2. Is there any documentation about this kind of migration? I can't do it
Updated on 2011-06-29T16:38:04Z at 2011-06-29T16:38:04Z by JP_Parkin
gibsonjc 100000G7BF10 Posts
giannatiozzo 120000J1JK10 PostsACCEPTED ANSWER
Re: Migrating Infosphere Warehouse from 9.5.2 to 9.7.32011-06-25T14:44:06Z in response to gibsonjcYes, I read this documentation but when I try to reuse the copy of websphere application server the system reply with the error message "the level is non supported" and the same message when I try to reuse the copy of DB2.
JP_Parkin 100000R2WA128 PostsACCEPTED ANSWER
Re: Migrating Infosphere Warehouse from 9.5.2 to 9.7.32011-06-29T16:38:04Z in response to giannatiozzoHi Gianna,
You need to upgrade WAS 7 in order to use ISW 9.7.x. We recommend WAS 18.104.22.168 since that is what was shipped with the 9.7.3 product, although earlier fixpack levels will also work ( and likely later ones as well ).
In terms of DB2, you will need a DB2 9.7 instance as the "client" for the Administration Console and the Design Studio.
Your underlying Warehouse database and the SQWCTRL database can be using either DB2 9.5 or 9.7. You cannot use the DWECTRL database from ISW 9.5.2 as the SQWCTRL database - it should be a different database in order to separate the metadata.