|
Problem IC69908
|
Status: Geschlossen |
DB2 MIGHT TRAP IN SQLNR_CLUSTERQUNSFINDCLUSTER() |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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. |
| verfügbare FixPacks: |
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
|
| Lösung |
First fixed in DB2 UDB Version 9.5, FixPak 6. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 14.07.2010
09.08.2010
09.08.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.5.,
9.5.,USERS
|
| Problem behoben lt. FixList in der Version |
