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!

dean@db2Dean.com

 

tp://twitter-badges.s3.amazonaws.com/twitter-a.png

 

tp://www.linkedin.com/img/webpromo/btn_profile_bluetxt_80x15.png

 

 

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

 

Previous

Articles

 

Hot Links

 

Manuals

 

Info Center

 

Informix

 

DB2/zOS

 

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 11.1.2.2.

 

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 11.1.0.0 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 11.1.1.1 and 11.1.2.2.  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

Change

Notes

Db2 Express-C

None

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

Db2 Developer-C

New

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

Db2 Developer Edition

None

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)

None

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)

None

All advanced features included except Advanced Recovery Features. 

Db2 Direct Standard Edition

New

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

New

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. 

 

11.1.1.1 and 11.1.2.2 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 11.1.1.1 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

 

 

Db2Dean’s

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