Mainframe Blog

Db2 10 end of support and what it means to you

3 minute read
Phil Grainger

While most of us are looking forward to the impending announcement from IBM as to when Db2 12 will be generally available, it’s worth taking a moment to look back over our shoulder. Not everyone sees Db2 12 on their immediate horizon and not everyone is yet safely migrated to Db2 11. If you have not migrated to Db2 11, read on.

IBM have announced that Db2 10 will cease to be supported from September 30, 2017 – a little over a year from now. So this defines the date by which EVERYONE should be migrated to Db2 11. At that point, the only Db2 versions fully supported by IBM will be Db2 11 and Db2 12 – unless you have made specific arrangements with IBM, that is.

It can take a typical Db2 installation (whatever one of those is) 6-12 months to migrate all of their subsystems from one Db2 version to another, so it is time to be making those migration plans on how to get to Db2 11 from where you are. Do not let the September 30 date become your deadline; plan to be safely on Db2 11 with a comfortable window before IBM ceases support. Bear in mind that you will have to progress through the three-phase migration process (CM, ENFM and NFM in turn) which just by itself can extend the time it takes to migrate – especially if you are also going to verify that it is possible to fall BACK from Db2 11 to Db2 10, or between any of the migration modes. On the bright side though, this will be the last time a Db2 migration will be handled this way. IBM have already told us there will be a single phase migration again for the step from Db2 11 to Db2 12.

If you have third-party tools, you will probably need to upgrade those when you migrate. For those of you who are BMC customers, you will need to be running with v11.1 version (or later) of our tools, although we recommend that you install the most recent release. Version 10 and earlier BMC tools do not support running in a Db2 11 environment. Other tools vendors probably have a similar minimum version statement for their tools to run with Db2 11. Remember, you will likely have to migrate all your tools to a Db2 11 compatible version before you start the actual Db2 version migration itself. Make sure you factor this into your Db2 upgrade plans.

If you are running Db2 9 or earlier, you have a whole different set of problems. Firstly, IBM withdrew Db2 10 from marketing on July 6, 2015 so it is already too late to order Db2 10 media. Secondly, you must migrate to Db2 10 to get to Db2 11 and beyond. There is no skip-migration available from Db2 9 to Db2 11 (or from Db2 10 to Db2 12 for that matter. The only recognized migration path is one version upgrade at a time until you reach Db2 12). Finally don’t forget, your journey to Db2 11 still has to be completed before September 30, 2017.

There is one ray of sunshine on the horizon. At IDUG North America in Austin, IBM talked about a possibility of shipping new function in Db2 continuously in the future. This infers that they would use Db2 12 as a base and incrementally add new abilities to it over time. So it just may well become much easier (and much faster) to get access to new Db2 functionality without necessarily going through the effort and complexity of migrating to a new release. IBM will be talking about this new delivery model on a webcast scheduled for Tuesday September 27th. Here is the title and link: Db2 for z/OS – Delivering New Capabilities Faster for Increased Productivity.

Finally, this makes me wonder whether anyone in our worldwide community has migrated Db2 subsystems through all 14 Db2 version changes there have been over the last 30+ years (1 -> 1.2 -> 1.3 -> 2.1 -> 2.2 -> 2.3 -> 3 -> 4 -> 5 -> 6 -> 7 -> 8 -> 9 -> 10 -> 11). When you look back over all those different versions, it’s been an amazing ride so far – and it makes you wonder what IBM have in their plans for the future of Db2.

Order now! Get your free Db2 collateral from BMC!

Get your free Reference Guide and Catalog Tables Poster for z/OS from BMC. This collateral helps Db2 for z/OS users with daily activities in administering and programming for Db2 on z/OS.

These postings are my own and do not necessarily represent BMC's position, strategies, or opinion.

See an error or have a suggestion? Please let us know by emailing

Business, Faster than Humanly Possible

BMC works with 86% of the Forbes Global 50 and customers and partners around the world to create their future. With our history of innovation, industry-leading automation, operations, and service management solutions, combined with unmatched flexibility, we help organizations free up time and space to become an Autonomous Digital Enterprise that conquers the opportunities ahead.
Learn more about BMC ›

About the author

Phil Grainger

Phil has 30 years experience of Db2, starting work long ago in 1987 with Db2 Version 1.2. Since then he has worked with all versions, including Db2 12.

From his beginnings as a Db2 DBA for one of the largest users of Db2 at that time in the UK, through his time at PLATINUM technology, his almost 10 years as Senior Principal Product Manager at CA and through to his current position with BMC Software, Phil has always been a keen supporter of user groups and is a regular speaker at both vendor sponsored and independent events. His work with IDUG includes being a past member of the European IDUG Planning Committee, an inductee into the IDUG Volunteer Hall of Fame and now Board Liaison for BMC Software

Phil has been honoured by IBM as an Analytics Champion from 2009 to 2017

Phil is now Lead Product Manager at BMC Software working in support of their Db2 tools portfolio

In addition, Phil is a regular contributor to the IDUG sponsored
Db2-L discussion list