db2Dean  a.k.a. Dean Compher a.k.a “The Dean of DB2” is here to answer your DB2 Questions !


Utah Events

None currently Scheduled


Nevada Events

March 2018:  Think Conference


Search db2Dean

Just for Grins Watch:

DB2 Infomercial by db2Dean  


Add your insights to the:

db2Dean and Friends


Get the Free Data Studio! 

Get DB2 Express-C Here!








Online Events

Technical Conference Calls


Other Events

None Currently Scheduled

db2Dean Discusses Big Data 



Welcome to db2Dean’s web site.  I’m Dean Compher an IBM IT Specialist who, along with my team, helps customers and prospective customers with DB2 on Linux, UNIX and Windows (LUW) technical questions and issues.  As this page makes painfully clear, I am a DBA and not a web designer, but I would be happy to get your DB2 questions answered or talk to you about the great features of DB2 or IBM Integration Products.  If you are looking at a new database solution or want to compare us to your existing database vendor, please do not hesitate to contact me about getting a presentation or just to ask questions.  My e-mail address is dean@db2Dean.com


I am located in Utah and primarily serve DB2/LUW and dashDB customers in the Western US, but I can forward requests to my peers in other technology and geographic areas as well.  My team also covers Big Data and Informix and products.  There are questions that I get on a regular basis, and I will write articles relating to them here.  I hope that you find them useful.  I also welcome suggestions for future content.  Click here for more information about me.



Favorite Links





Hot Links




Info Center






DB2 i5/OS


DB2 Connect


Best Practices












Db2 Edition, Support & Fixpack Updates

Dean Compher

31 October 2017


IBM is putting a renewed focus on Db2 on-premises editions and there is a lot happening with the product.  This is fantastic news to someone who calls himself db2Dean!  These changes run the gamut from cosmetic changes like new names, through feature packaging changes to new capabilities and new ways of installing and supporting Db2.  Because significant features are being released with each new fix pack, I anticipate this will accelerate.  This article is current as of Db2


The first thing you will probably notice is the change of name from “DB2” to “Db2”.  Along with this some of the cloud variants are now called Db2 as well, but that is a topic for another article.  All traditional on-premises software Db2 platforms have the new “Db2” handle, but there have been some changes as you can see from the following table:


Current name

Most Recent Previous Name

Db2       (yep, just Db2)

DB2 for Linux Unix and Windows (DB2/LUW)

Db2 for z/OS

DB2 for z/OS

Db2 for i

DB2 for i


As I noted fix packs will generally include new features for Db2 11.1.  The format of fix pack numbers is VV.RR.MM.FF defined as follows:

VV      = Version number

RR       = Release number

MM     = Modification number

FF       = Fixpack number


For some time the newest VV.RR will all be 11.1.  If MM is ever 0 that means that there were no modifications and only fixes were included.  If FF is ever 0 that means that there were no fixes included and only new features were included with the fix pack.  The General Availability (first release) of the current version was as you would expect.  So far there have been two fix packs for 11.1 and both included both modifications and fixes.  So, the numbers were and  The Knowledge Center has a summary of the fixpacks



Continuing Support 9.7 and 10.1


One nice surprise is that some support will continue to be provided for Db2 9.7 and 10.1 even though they went out of support on 30 September 2017.  Assuming you continue to pay maintenance, this means that you can still contact IBM support for these versions and they will help you within some limitations.  The biggest items not support is that they will stop investigations if they determine that you have hit a previously unknown defect and only fixes already created will be provided.  See this article about Db2 Continuing Support for the details about what is and is not covered. 



Db2 Editions


The packaging of DB2 underwent some significant changes with version 11.1 from 10.5.  There are some new editions, some editions went away and some changed the features that they include.


Edition in 11.1



Db2 Express-C


No charge, Only community support, limited features, limited to 2 cores, 16GB RAM

Db2 Developer-C


No charge, Only community support, has ALL features, limited to 4 cores, 16GB RAM,  Docker Container install available.

Db2 Developer Edition


User based bundle of all editions for non-production uses.

Db2 Workgroup Server Edition (WSE)

Features Added

Now includes Native Encryption, limited federation, limited pureScale, MDC, and parallelism features and others.  Limited to 16 cores and 128 GB RAM. 

Db2 Advanced Workgroup Server Edition (AWSE)


All advanced features included except Advanced Recovery Features.  Limited to 16 cores and 128 GB RAM

Db2 Enterprise Server Edition (ESE)

Features Added

Now includes Native Encryption, limited federation, limited pureScale. 

Db2 Advanced Enterprise Server Edition (AESE)


All advanced features included except Advanced Recovery Features. 

Db2 Direct Standard Edition


Features similar to Db2 WSE.  Licensed by virtual core and not by physical core so you don’t need to know the underlying processor technology to purchase it.  Licensing makes it easy to move around between your premises and the cloud.

Db2 Direct Advanced Edition


Features similar to Db2 AESE.  Licensed by virtual core and not by physical core so you don’t need to know the underlying processor technology to purchase.  Licensing makes it easy to move around between your premises and the cloud.


It is interesting to note that WSE and ESE are nearly identical in the features they offer and the that AWSE and AESE are nearly identical in the features they offer.  The main difference being that the workgroup editions are limited to 16 cores and 128 GB of RAM.   See the Functionality in Db2 product editions and Db2 offerings chart in the Knowledge Center for the details about which features are in which editions.


If you have a restricted use license of DB2 ESE that you got as part of another IBM product like WebSphere Application Server and you want to use some of the advanced features of Db2 you are in luck!  You can now buy a trade-up part called Db2 OEM High Capacity Add-on to get all of the features of AESE.  Prior to this you had to purchase new licenses of Db2 AESE.  This trade-up allows you to use Data Server Manager Enterprise Edition monitoring, Compression, pureScale and all of the other advanced features. 


Download and Go


An effort is underway to make it very easy to get Db2 loaded on your machine.  Docker and Docker Containers are playing a large role in this.  The first entry in this experience is the Download and Go Db2 Developer Community Edition container.  This will install Docker if you don’t already have it and installs Db2 in a container.  I found this install quite easy and you can read about how to do this in my Db2 Docker article.  You can just download this Db2 container and start using Db2.  With a normal Db2 download you have to go through an install process. and highlights


In the summary of the fixpacks article you can see the list of changes in the two fix packs released so far, but I wanted to highlight a few here.  You can also read about them in the Db211 Ebook.


·      A Hardware Security Module can be used as of for enterprise key management

·      SSL for federation to Db2 Family Sources

·      Asynchronous UNDO allowing connectivity to the database during crash recovery.

·      Multiple agents involved in inserts to column organized tables.

·      Enhanced JSON processing

·      Indexes on BLU tables (Preview Mode – not production ready)




As you can see there are many good things going on in Db2 Land.  If I missed any you think are important then please share them on my Facebook Page or my db2Dean and Friends Community along with any other comments you may have. 


Top | Search




Other  Interests


Real Estate Investing


Quail at my Bird Feeder


Mary Lou’s Stained Glass


2B Hawaii Condo Rental


1B Hawaii Condo Rental


Ski Condo Rental


My Googlegängers


Fortune Cookie