DB2 Provider version information


The following table contains various information about several versions of the DB2 Providers included with Host Integration Server (HIS) as well as the Microsoft OLE DB Provider for DB2 (DB2OLEDB) included in SQL Server Feature Packs.

As a side note for those that might not be aware, the Microsoft OLE DB Provider for DB2 included with SQL Server Feature Packs is based on the OLE DB Provider for DB2 that is included with Host Integration Server.

Here is an explanation of the information in each column of the table:

  • Product – The product for which the rest of the row information applies to. For example, DB2OLEDBv1 is the Microsoft OLE DB Provider for DB2 V1.0 that was included in the SQL Server 2005 Feature Pack.
  • File Version – This indicates the released file version of the DB2 Provider. If you were to install the Microsoft OLE DB Provider for DB2 V5.0 (DB2OLEDBv5) from the SQL Server 2014 Feature Pack, you would find that the file version of msdrda.dll is 9.0.2148.0.
  • Supported for fixes? – This information indicates if the specific version is still in Mainstream support, which means that new fixes can still be provided for that version. “No” indicates that new fixes cannot be provided for that version. If the column contains a date, that is the date that the product transitions from Mainstream Support to Extended Support at which time new fixes will no longer be done.
  • Dependent Product’s Lifecycle – This column lists product to which the DB2 Provider version’s lifecycle is associated with. This is pretty obvious for the DB2 Providers included with HIS because the HIS lifecycle applies. For the SQL Server Feature Provider versions, the lifecycle is associated with the lifecycle of the specific SQL Server version that that DB2 Provider was included with. The links take you to the product’s lifecycle information on http://support.microsoft.com/lifecycle.
  • DB2 for z/OS (Mainframe) – The versions of IBM DB2 for z/OS supported by this version of the DB2 Provider.
  • DB2 for iSeries (AS/400) - The versions of IBM DB2 for iSeries (AS/400) supported by this version of the DB2 Provider.
  • DB2 for LUW (Linux, Unix, Windows) - The versions of IBM DB2 for LUW supported by this version of the DB2 Provider.

 

Product

File Version

Supported for fixes? (Date Mainstream support ends)

Dependent Product’s Lifecycle

DB2 for z/OS (Mainframe)

DB2 for iSeries (AS/400)

DB2 for LUW (Linux, Unix, Windows)

DB2OLEDBv1

7.0.2413.0

No

SQL Server 2005

v7, v8

v5r2, v5r3, v5r4

v8.2, v9

HIS 2006

7.0.2758.0

No

HIS 2006

v7, v8

v5r2, v5r3, v5r4

v7.1

DB2OLEDBv1 SP2

7.0.3038.0

No

SQL Server 2005

v7, v8

v5r2, v5r3, v5r4

v8.2, v9

DB2OLEDBv2

7.0.3175

July 8, 2014

SQL Server 2008

v8, v9

v5r3, v5r4

v9

HIS 2006 SP1

7.0.4115.0

No

HIS 2006 SP1

v7, v8

v5r2, v5r3, v5r4

v7.1

HIS 2009

8.0.3608.0

July 8, 2014

HIS 2009

v8, v9

v5r4, v6r1

v8.2

DB2OLEDBv3

8.0.4294.0

July 8, 2014

SQL Server 2008 R2

v8.1, v9.1

v5r4, v6r1

v9.1, v9.5, v9.7

HIS 2010

8.5.4224.0

January 12, 2016

HIS 2010

v8.1, v9.1, v10 (with CUs) *

v5r4, v6r1, v7r1 (with CUs) *

v9.1, v9.5, v9.7

DB2OLEDBv4

9.0.1356.0

July 11, 2017

SQL Server 2012

v8.1, v9.1, v10

v5r4, v6r1, v7r1

v9.1, v9.5, v9.7

HIS 2013

9.0.2102.0

January 8, 2019

HIS 2013

v9.1, v10

v6r1, v7r1

v9.7, v10

DB2OLEDBv5

9.0.2148.0

July 9, 2019

SQL Server 2014

v9.1, v10

v6r1, v7r1

v9.7, v10

 

* The DB2 Providers included with HIS 2010 were not supported for use with IBM DB2 for z/OS V10 or IBM DB2 for iSeries V7R1 when HIS 2010 was released. Support for these two DB2 versions was added later. We recommend that you have the current HIS 2010 Cumulative Update (CU) applied when integrating with these DB2 versions. As of June 2014, the current HIS 2010 CU is CU9.

You can refer to the Update Center for Microsoft Host Integration Server and Microsoft OLE DB Provider for DB2 to see the latest updates for HIS and the DB2OLEDB providers.

In addition, please refer to the Microsoft Support Lifecycle site for details on the various lifecycle stages.

Comments (1)
  1. Deborah says:

    DB2 for z/OS v11 is not listed at all.  We are  having trouble with HIS and the new Synchronous Receive used by DB2 because the application is closing the active connection before COMMITting on DB2.  Do you have any additional info about HIS and DB2 11?  Thanks!

Comments are closed.

Skip to main content