DB2 CONNECT / DB2CONNCT / A10 - DB2

At the time of Connection.Close the DB2 .NET driver ensures the 
statements are freed. Looks like unfortunately Microsoft Entity 
Framework (EF) holds the ownership of the Command objects until 
it closes the connection.  This can result in a CLI0129E error. 
 
CLI0129E  An attempt to allocate a handle failed because there 
are no more handles to allocate. 
 
The DB2 driver will not be able to free statement handles when 
EF keeps the ownership of the command 
object associated with the statement handles. The real problem 
is with Microsoft Entity Framework (EF). 
 
Since the application still wants to keep such a high number of 
updates within a transaction, IBM can provide a possible 
workaround. It is by freeing up some of the statement handles 
associated with the command object that is not yet come for 
disposal. 
 
The real fix should come from Microsoft Entity Framework

**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 users on Windows OS                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V10.1 Fix Pack 1 or higher                    * 
****************************************************************

Try to minimize the number of statements within a single 
transaction.  That should reduce the number of statement handles 
and sections required by the DB2 driver.

DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

First fixed in DB2 V10.1 Fix Pack 1

Try to minimize the number of statements within a single 
transaction.  That should reduce the number of statement handles 
and sections required by the DB2 driver.

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

14.06.2012
06.11.2012
06.11.2012