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
Re: Migrating Infosphere Warehouse from 9.5.2 to 9.7.32011-06-24T22:44:09ZThis is the accepted answer. This is the accepted answer.Hi. Have you seen this Migration information:
giannatiozzo 120000J1JK10 Posts
Re: Migrating Infosphere Warehouse from 9.5.2 to 9.7.32011-06-25T14:44:06ZThis is the accepted answer. This is the accepted answer.
- gibsonjc 100000G7BF
JP_Parkin 100000R2WA128 Posts
Re: Migrating Infosphere Warehouse from 9.5.2 to 9.7.32011-06-29T16:38:04ZThis is the accepted answer. This is the accepted answer.
- giannatiozzo 120000J1JK
You need to upgrade WAS 7 in order to use ISW 9.7.x. We recommend WAS 126.96.36.199 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.