Unanswered: problems in migrating from db2 udb v 7.2 eee to v8.1
I need to migrate from db2 udb v 7.2 extended enterprise edition to db2 v 8.1 . What are the problems likely to be faced ? And what are the issues of compatiblity with j2ee v 1.3 . Also what are differences between db2 v7.2 eee stored procedure builder and v 8.1 devlopment center ?
We are in the process of migrating our databases from 7.2 to 8.1. We are taking a easy route. We are replacing each server with new hardware, so we can install 8.2 on the new server and then just copy the data to the new server. We did not get new hardware for our development servers, but we have two (which are mirrors of each other) to use, so we did these one at a time. We did the secondary first, moved everyone to it for a while, then we did the primary. It worked out real good.
The only thing you will need to know for sure is that you will still need to stay with the 7.2 clients until all the servers have been upgraded.
We have not yet gone to using j2ee, we are still client/server-- so I cannot help you there.
Since we still have a few 7.2 servers, I have not upgraded the client on my primary development client PC, which means that I am still using the SPB. I have installed the DC on my secondary PC to check it out.
It looks more like an IDE than the SPB. You are also supposed to do alot more with it--UDFs, structured types, triggers, views and more.
I cannot wait until all our servers are upgraded so I can use it.
possible according to IBM to restore from 7.2 to 8.1.2
Spoke with IBM DB2 database engine support this week about performing a redirected restore from one server running DB2 UDB 7.2 on AIX into a new server using DB2 UDB 8.1.2. The engineer said that this is possible. I will test it next week and keep you posted on how it goes. Should make upgrading and migrating the current database environment the best way to do it.