|
Problem IC66837
|
Status: Closed |
INSTANCE ABEND DUE TO STACK OVERFLOW WITH FUNCTION NOTPD_TRAVERSE__9SQLNQ_PIDFP9SQLNQ_OPRI |
| product: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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. |
| available fix packs: |
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
|
| Solution |
|
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC70337
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 04.03.2010
16.06.2011
16.06.2011 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.10
|
 |
