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 |