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 IC77368 Status: Geschlossen

EXPLAIN_DIAGNOSTIC TABLE MAY NOT HAVE DIAGNOSTICS FOR OPTIMIZATION PROFILE

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
Under very limited conditions, the optimizer may not 
consistently 
be able to log diagnostic information into the 
EXPLAIN_DIAGNOSTIC table when an Optimization Profile is not 
applied to a particular query. 
 
The conditions under which this can occur include: 
- multiple queries compiling at the same time 
- statement heap is AUTOMATIC 
- An Optimization Profile matches the query being compiled 
- An error exists in the Optimization Profile preventing it from 
being applied to the generation of the Query Access Plan. 
 
Under these conditions, the optimizer may not log the 
Optimization Profile errors into the EXPLAIN_DIAGNOSTIC tables, 
nor will it return an SQL0101N (The statement is too long or too 
complex) error, nor an SQLSTATE 54001.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of DB2LUW using statement heap automatic and           * 
* optimization profiles                                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Under very limited conditions, the optimizer may not         * 
* consistantly be able to log diagnostic information into the  * 
* EXPLAIN_DIAGNOSTIC table when an Optimization Profile is not * 
* applied to a particular query.                               * 
*                                                              * 
* The conditions under which this can occur include:           * 
* - multiple queries compiling at the same time                * 
* - statement heap is AUTOMATIC                                * 
* - An Optimization Profile matches the query being compiled   * 
* - An error exists in the Optimization Profile preventing it  * 
* from being applied to the generation of the Query Access     * 
* Plan.                                                        * 
*                                                              * 
* Under these conditions, the optimizer may not log the        * 
* Optimization Profile errors into the EXPLAIN_DIAGNOSTIC      * 
* tables, nor will it return an SQL0101N (The statement is too * 
* long or too complex) error, nor an SQLSTATE 54001.           * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* The customer should upgrade to DB2 Version 9.7 for Linux,    * 
* UNIX, and Windows Fix Pack 5.                                * 
****************************************************************
Local-Fix:
Re-prepare/re-compile the query with statement heap set to a 
fixed value.
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
The fix for this problem is included in DB2 Version 9.7 for 
Linux, UNIX, and Windows Fix Pack 5. 
 
When an out of memory condition is encountered during 
compilation of an SQL Statement that requires the loging of 
Explain Diagnostic information for an Optimization Profile that 
contains errors, an SQL0101N (The statement is too long or too 
complex) error with an SQLSTATE 54001 will be returned.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
06.07.2011
19.01.2012
19.01.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.
Problem behoben lt. FixList in der Version
9.7.0.5 FixList