Results 1 to 8 of 8
  1. #1
    Join Date
    Aug 2009
    Posts
    42

    Unanswered: Latest version of DB2

    We're running 9.5 ESE and planning to upgrade next year. What's the latest version we're eligible to upgrade to - 10.1 or 10.5? Is 10.5 an extra cost feature?

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    It depends on your organization's license conditions. I have a feeling that not many people on this forum can tell you what they are.

    You might have better luck speaking with your IBM rep.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by rdba View Post
    We're running 9.5 ESE and planning to upgrade next year. What's the latest version we're eligible to upgrade to - 10.1 or 10.5? Is 10.5 an extra cost feature?
    10.5 is a major release, not a feature. Contact the person in your organization who has an Passport Advantage account with IBM. This is where you will have to get the license file if you are entitled.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  4. #4
    Join Date
    Aug 2009
    Posts
    42
    Checked Passport Advantage, we're entitled to upgrade to 10.1 & 10.5. I read you can't migrate from 9.5 to 10.5, have to go to 9.7 first and then 10.5.
    Is it better to migrate to 10.5 or 10.1 base code is just about the same as 10.5? Does 10.5 BLU Accelerator is an additional license we have to purchase if you want to have it? (we have ESE)?

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by rdba View Post
    Checked Passport Advantage, we're entitled to upgrade to 10.1 & 10.5. I read you can't migrate from 9.5 to 10.5, have to go to 9.7 first and then 10.5.
    Is it better to migrate to 10.5 or 10.1 base code is just about the same as 10.5? Does 10.5 BLU Accelerator is an additional license we have to purchase if you want to have it? (we have ESE)?
    There is no reason to ever install base code (GA) if a fixpack has been released (unless you are suicidal). Fixpacks are cumulative and can be used for a fresh install.

    BLU Accelerator is available in ESE, however columnar tables are primarily for data warehouses, and even then they usually only work well if a query accesses a relatively small percentage of the columns in a table. One thing it does very well is to consume huge amounts of CPU power.

    10.5 does have other new features besides BLU, but of course probably has more bugs since there has only been one fixpack (and it was released very early due to the number of severe problems with 10.5 GA).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  6. #6
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Has anyone tried double migration on the same day? What I mean by double migration is something like: v9.5 -> v9.7 -> v10.5.

  7. #7
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by db2girl View Post
    Has anyone tried double migration on the same day?
    How's that different from doing that on different days?
    ---
    "It does not work" is not a valid problem statement.

  8. #8
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Limited time for testing, but huge time savings if everything is ok.

Posting Permissions

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