Hi,

Our client wants to migrate from DB2 8.2 to DB2 9.5. We have a J2ee application running at client location.

Can you please guide me as to what impact this migration will have on the application.. i.e. what all has changed from DB2 8.2 to DB2 9.5 and what all we'll have to modify in the application so that it works on DB2 9.5.

Please help.

PS-Currently on DB2 8.2, the application is working fine.

if upgrading just the db - it should be no problem

Thanks przytula_guy for the reply.

But one of the teams here last yr moved from 8.2 to 9.1 and they had to modify long to sqlint in their code.But that was for C/C++ code.

Ours is java and we are moving to 9.5, so what all changes in java code and/or sqls used I'll have to change ?

Thanks.

Migration to DB2 Version 9.5

Re-evaluate your JDBC driver you use for your J2EE. Using a type-2 driver now? You should be able to switch to the type-4 driver so you can drop the db2-client software on your J2EE server and run 100% native java.

In other words: they had to fix the bugs in their code because they didn't use LONGERROR YES/NO in their prepare statements correctly.

Until version 8, the java directory present under db2 installed binaries used to come with a file 'usejdbc2'. In our environment, all the java applications use 'usejdbc2' to source the jdbc jar files but as 'usejdbc2' is not present in version 9.5 any more, make sure the java applications are not coded to use the file 'usejdbc2' instead make them point to db2java.zip and db2jcc.jar/db2jcc4.jar depending up on the JDK level.