|
Problem IC66837
|
Status: Geschlossen |
INSTANCE ABEND DUE TO STACK OVERFLOW WITH FUNCTION NOTPD_TRAVERSE__9SQLNQ_PIDFP9SQLNQ_OPRI |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problembeschreibung: |
During SQL/XQuery compilation, a query being compiled may cause
the DB2 instance to abend due to a stack overflow exception.
Although new behaviour in DB2 Version 9.5 should ideally cause
the DB2 agent to dump an sqlcode SQL0973N upon detecting such a
scenario, this may not happen when a very large predicate,
e.g., deeply nested series of NOTs, etc., is present in the
query. The stack trace from such an abend will look
like:
-------Frame------ ------Function + Offset------
0x0900000005740BEC
notpd_traverse__9sqlnq_pidFP9sqlnq_opriPbT3CP3loc + 0x14
0x090000000574164C
notpd_traverse__9sqlnq_pidFP9sqlnq_opriPbT3CP3loc + 0xA74
0x090000000574164C
notpd_traverse__9sqlnq_pidFP9sqlnq_opriPbT3CP3loc + 0xA74
0x090000000574164C
notpd_traverse__9sqlnq_pidFP9sqlnq_opriPbT3CP3loc + 0xA74
... |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* During SQL/XQuery compilation, a query being compiled may *
* cause the DB2 instance to abend due to a stack overflow *
* exception *
****************************************************************
* PROBLEM DESCRIPTION: *
* During SQL/XQuery compilation, a query being compiled may *
* cause the DB2 instance to abend due to a stack overflow *
* exception *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 LUW db2_v91fp10 *
**************************************************************** |
| Local-Fix: |
In DB2 Version 9.5, users have the ability to control the size
of the runtime stack used by a DB2 agent.
Consequently,increasing the value for the "agent_stack_sz"
database configuration parameter will help workaround the
issue. |
| verfügbare FixPacks: |
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
|
| Lösung |
|
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC70337
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 04.03.2010
16.06.2011
16.06.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 9.1.0.10
|
 |
