|
Problem IC77697
|
Status: Closed |
FURTHER PERFORMANCE IMPROVEMENTS TO VS.NET ENTITY DATA MODEL TO EXPLOIT OPTIMIZER CHANGES FOR DB2 FOR LUW SERVERS. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
This is an extension of APAR# IC77367 which improved the
performance of the Microsoft Visual Studio .NET Entity Data
Model Wizard when connecting to DB2 for Linux, Unix, Windows
(LUW) or for DB2 for z/OS.
This APAR is added to further improve the performance against
DB2 for LUW servers, specifically DB2 v9.1 FP10, DB2 v9.5 FP4
and DB2 v9.7 GA but modifying the generated query so that it
exploits an added internal optimizer change on those servers.
This should help improve the performance radically against these
kinds of servers. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Windows .NET users *
****************************************************************
* PROBLEM DESCRIPTION: *
* This is an extension of APAR# IC77367 which improved the *
* performance of the Microsoft Visual Studio .NET Entity Data *
* Model Wizard when connecting to DB2 for Linux, Unix, Windows *
* (LUW) or for DB2 for z/OS. *
* *
* This APAR is added to further improve the performance *
* against DB2 for LUW servers, specifically DB2 v9.1 FP10, DB2 *
* v9.5 FP4 and DB2 v9.7 GA but modifying the generated query *
* so that it exploits an added internal optimizer change on *
* those servers. *
* *
* This should help improve the performance radically against *
* these kinds of servers. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 v9.7, Fixpak 5 *
**************************************************************** |
| Local Fix: |
|
| 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, Fixpak 5 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 25.07.2011
07.12.2011
07.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
