Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2008
    Location
    Chennai
    Posts
    111

    Unanswered: DB2 Upgrade from 8.2 to ?

    Hello,

    After experiencing tablespace issues for long time...we have now decided to upgrade the DB2 veriosn.
    The current version is DB2 8.2 UDB O/S is Windows 2003 (32bit) and HADR has been set with standby node.

    We have only one instence and One database.
    The database size is 500GB.

    Can someone suggest me that what is the best version to upgrade and what is the latest version is now available please?

    Also, Is it better to go with 64 bit DB2 ?

    Thanks.

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    The latest the greatest -> v9.7

    If you don't feel comfortable migrating to the latest, then go with v9.5.

  3. #3
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Yes, it is better to go with 64 bit. You have so much more memory to play with.

    Andy

  4. #4
    Join Date
    Dec 2008
    Location
    Chennai
    Posts
    111

    db2 32bit & 64bit

    Thanks for your reply and need some more advise.

    We will build the new DB server with 64bit OS & DB2. But our application servers have the 32 bit DB2 V8.2 client running.
    If I upgrade the application servers with 32 bit DB2 9.5 client, will this work?

    or Client and the server must be the same 64 bit ? Please advise.

    Thanks,

  5. #5
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    If the application servers are different machines, then it does not matter. The bitness of the client has nothing to do with the bitness of the DB2 server.

    Andy

  6. #6
    Join Date
    Jan 2009
    Location
    United Kingdom
    Posts
    77
    If you go to 9.5 , worth reading up a bit about multi threaded - there are some differences in the way memory is managed by DB2 9.5

Posting Permissions

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