|
Problem IC69908
|
Status: Closed |
DB2 MIGHT TRAP IN SQLNR_CLUSTERQUNSFINDCLUSTER() |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
During SQL/XQuery compilation, 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 DB2 9.5
and later versions, the DB2 agent should dump an sqlcode
SQL0973N upon detecting such scenario, however, because of a
missed stack check in the recursive function
sqlnr_clusterQunsFindCluster(), db2 will bring down the
instance.
The stack trace should look like the following:
ossDumpStackTraceEx
OSSTrapFile::dumpEx
OSSTrapFile::dump
sqlo_trce
sqloEDUCodeTrapHandler + 0x0101
sqlnr_clusterQunsFindCluster
sqlnr_clusterQunsFindCluster--> this function will repeat
several times.
: |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* During SQL/XQuery compilation, a very large and *
* complexpredicate in the query being compiled may cause the *
* DB2instance to abend due to a stack overflow exception. In *
* DB29.5and later versions, the DB2 agent should dump an *
* sqlcodeSQL0973N upon detecting such scenario, however, *
* because of amissed stack check in the recursive *
* functionsqlnr_clusterQunsFindCluster(), db2 will bring down *
* theinstance.The stack trace should look like the *
* following:ossDumpStackTraceExOSSTrapFile::dumpExOSSTrapFile::d
* + *
* 0x0101sqlnr_clusterQunsFindClustersqlnr_clusterQunsFindCluster
* this function will repeatseveral times.: *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 UDB Version 9.5, FixPak 6. Also, In *
* v9.5,users have the ability to increase the db2 agentruntime *
* stack thru the AGENT_STACK_SZ db cfg parameter.Thismight *
* help to workaround this problem. *
**************************************************************** |
| Local Fix: |
In v9.5, users have the ability to increase the db2 agent
runtime stack thru the AGENT_STACK_SZ db cfg parameter. This
might help to workaround this problem. |
| available fix packs: |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 UDB Version 9.5, FixPak 6. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 14.07.2010
09.08.2010
09.08.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.,
9.5.,USERS
|
| Problem solved according to the fixlist(s) of the following version(s) |
