|
Problem IC81268
|
Status: Closed |
CLI0129E RETURNED FROM A DB2 .NET Entity Framework APPLICATION |
| product: |
DB2 CONNECT / DB2CONNCT / 970 - DB2 |
| 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.
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 |
| Problem Summary: |
****************************************************************
* 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 *
**************************************************************** |
| Local Fix: |
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. |
| available fix packs: |
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
|
| Solution |
First fixed in DB2 V9.7 FP 6 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC84436
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 08.02.2012
05.06.2012
21.02.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
