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

QUERY COMPILER INCORRECTLY RETURNS SQLCODE -101 WHEN IT SHOULD NOT.

Produkt:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problembeschreibung:
Under rare conditions, the query compiler might return sqlcode 
-101 when it should not. 
 
A db2trc flw output shows one of the following functions 
sqlno_find_jp_hash_table or sqlno_do_insert_qpt in the call 
stack when function sqlno_alloc_aub receives return code 
SQLO_NOMEM_STMTH from the functions it calls.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Under rare conditions, the query compiler might return       * 
* sqlcode                                                      * 
* -101 when it should not.                                     * 
*                                                              * 
*                                                              * 
*                                                              * 
* A db2trc flw output shows one of the following functions     * 
*                                                              * 
* sqlno_find_jp_hash_table or sqlno_do_insert_qpt in the call  * 
*                                                              * 
* stack when function sqlno_alloc_aub receives return code     * 
*                                                              * 
* SQLO_NOMEM_STMTH from the functions it calls.                * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Review 970 parent APAR IC72906, and/or the children APAR(s)  * 
* of  IC72906, to determine the product version containing the * 
* fix.                                                         * 
****************************************************************
Local-Fix:
It is possible that a small increase in the STMTHEAP 
setting will allow the statement to compile without experiencing 
the -101 error.
Lösung
This problem will be fixed in a future version of DB2.
Workaround
See local fix.
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
02.12.2010
12.12.2010
12.12.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.0
Problem behoben lt. FixList in der Version