DB2 - Problembeschreibung
Problem IC70104 | Status: Geschlossen |
DB2 MIGHT TRAP IN SQLNR_CLUSTERQUNSFINDCLUSTER() OR ISSUE SQL0973N EVEN AFTER INCREASING AGENT_STACK_SZ TO THE TOP RANGE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
During SQL/XML or XQuery compilation, before DB2 9.5 FP6 or earlier versions, a very large and complex predicate in the query being compiled may cause the DB2 instance to abend due to a stack overflow exception. In the stack trace, the function sqlnr_clusterQunsFindCluster() is repeated. DB2 might also issue SQL0973N even after AGENT_STACK_SZ has been increased to the top range. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * During SQL/XML or XQuery compilation, before DB2 9.5 FP6 * * orearlier versions, a very large and complex predicate in * * thequery being compiled may cause the DB2 instance to abend * * dueto a stack overflow exception. In the stack trace, * * thefunctionsqlnr_clusterQunsFindCluster() is repeated. DB2 * * might alsoissue SQL0973N even after AGENT_STACK_SZ has been * * increasedto the top range. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.5 Fix Pack 7. * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in DB2 Version 9.5 Fix Pack 7. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 22.07.2010 15.11.2010 15.11.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP7 | |
Problem behoben lt. FixList in der Version | |
9.1.0.7 | |
9.5.0.7 |