Latest versionsfixlist
11.1.0.6 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26
Question in the chat LiveZilla Live Help

DB2 - Problem description

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)
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.