|
Problem IC77367
|
Status: Closed |
QUERY GENERATED BY .NET ENTITY DATA MODEL WIZARD TAKES TOO LONG,AND CAN FAIL WITH SQL0905N ERROR |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
DB2 v9.7 FP4 introduced support for Visual Studio .NET 2010. In
VS.NET 2010 when using the .NET Entity Data Model wizard, the
query that gets generated can take a very long time on large
databases which can cause the Entity Data Model wizard to hang.
On DB2 for z/OS the query can return an SQL0905N error due to
work load manager terminating the query:
ERROR [57014] [IBM][DB2] SQL0905N Unsuccessful execution due to
resource limit being exceeded. Resource name = "ASUTIME", limit
= "000000000291" CPU seconds ("000013000000" service units)
derived from "SYSIBM.DSNRLST01". |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Windows users using DB2 .NET provider *
****************************************************************
* PROBLEM DESCRIPTION: *
* see Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7, Fixpack 5 *
**************************************************************** |
| Local Fix: |
It might be possible to improve the query execution time to a
reasonable rate by creating filters on the database connection.
A filter will reduce the amount of rows DB2 needs to go through
to return the proper results back to Microsoft Visual Studio. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
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 Version 9.7, Fixpack 5 |
| Workaround |
see Local Fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 06.07.2011
21.12.2011
21.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
