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 https://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.

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

• Anonymous
  December 17, 2014
  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!