DB2 - Problembeschreibung
Problem IC77697 | Status: Geschlossen |
FURTHER PERFORMANCE IMPROVEMENTS TO VS.NET ENTITY DATA MODEL TO EXPLOIT OPTIMIZER CHANGES FOR DB2 FOR LUW SERVERS. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * 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: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows | |
Lösung | |
First fixed in DB2 Version 9.7, Fixpak 5 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 25.07.2011 07.12.2011 07.12.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7. | |
Problem behoben lt. FixList in der Version | |
9.7.0.5 |