DB2 - Problembeschreibung
Problem IC63521 | Status: Geschlossen |
DB2 CAN RETURN SQL0101N WHEN COMPILING A COMPLEX SQL QUERY THOUGH STMTHEAP IS AUTOMATIC | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
When the database configuration parameter STMTHEAP is set to AUTOMATIC and there is enough memory in APPL_MEMORY and INSTANCE_MEMORY, DB2 can still return SQL0101N when compiling a complex SQL query. To assess if you are experiencing the problem, which typically does not consistently return a -101, review the sqlcode returned when a -101 is not received from statement compilation: a) If you observe a +437 rc2 from sqlca.sqlerrp=SQLNOxxx (where xxx=24D for V95 Fix Pack 0,1,2 and xxx=24E for V95 Fix Pack 3,4,5), then it is the problem. b) If you observe a +437 that is not case a, then it could be the problem, but it can not be confirmed definitively. c) If you observe no warnings, then it is not the problem. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * DB2 CAN RETURN SQL0101N WHEN COMPILING A COMPLEX SQL * * QUERYTHOUGH STMTHEAP IS AUTOMATIC * **************************************************************** * RECOMMENDATION: * * Upgrade to 9.5 FP6 * **************************************************************** | |
Local-Fix: | |
Use optimization level 2 to compile the query | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows | |
Lösung | |
DB2 CAN RETURN SQL0101N WHEN COMPILING A COMPLEX SQL QUERY THOUGH STMTHEAP IS AUTOMATIC | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC63522 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 01.10.2009 31.05.2010 31.05.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP6 | |
Problem behoben lt. FixList in der Version |