Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2008
    Posts
    16

    Unanswered: Upgradation - DB2 8.2 -> DB2 9.5

    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.

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    if upgrading just the db - it should be no problem
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Nov 2008
    Posts
    16
    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.

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    ---
    "It does not work" is not a valid problem statement.

  5. #5
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    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.

  6. #6
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Quote Originally Posted by Hello1 View Post
    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.
    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.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  7. #7
    Join Date
    Jun 2009
    Posts
    272
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •