DB2 CONNECT / DB2CONNCT / 970 - 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 have not yet come for 
disposal. 
 
The real fix should come from Microsoft Entity Framework

**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 V9.7 users on Windows OS                                 * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* 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.                                                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.7 FP 6                                     * 
****************************************************************

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 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in DB2 V9.7 FP 6

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC84436 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

08.02.2012
05.06.2012
21.02.2013

9.7.FP6