home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
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

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 FixList