DB2 - Problembeschreibung
Problem IC67001 | Status: Geschlossen |
FEDERATED ONLY: TOO MANY OR PREDICATES MAY LEAD TO STACK EXHAUST ION AND CRASHWHEN COMPILING THE QUERY | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
Too many OR predicates may lead to stack exhaustion and crash when compiling the query. db2diag.log may contain the entries like this. 2010-02-02-09.53.08.422165+540 E21124851A621 LEVEL: Severe PID : 29538 TID : 100 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : PRODDB APPHDL : 0-16 APPID: *LOCAL.db2inst1.100202005306 AUTHID : DB2INST1 EDUID : 100 EDUNAME: db2agent (PRODDB) 0 FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:30 MESSAGE : ADM0502C The DB2 instance has terminated abnormally. To remedy this problem, increase the AGENT_STACK_SZ DBM configuration parameter. Contact IBM Support for further assistance. 2010-02-02-09.53.08.422799+540 E21125473A462 LEVEL: Severe PID : 29538 TID : 100 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : PRODDB APPHDL : 0-16 APPID: *LOCAL.db2inst1.100202005306 AUTHID : DB2INST1 EDUID : 100 EDUNAME: db2agent (PRODDB) 0 FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:40 DATA #1 : <preformatted> Current stack size = 8388608 2010-02-02-09.53.08.958226+540 E21125936A549 LEVEL: Severe PID : 29537 TID : 2 PROC : db2wdog 0 INSTANCE: db2inst1 NODE : 000 EDUID : 2 EDUNAME: db2wdog 0 FUNCTION: DB2 UDB, base sys utilities, sqleWatchDog, probe:20 MESSAGE : ADM0503C An unexpected internal processing error has occurred. ALL DB2 PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN. Diagnostic information has been recorded. Contact IBM Support for further assistance. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Agent stack is set to a rather small size * **************************************************************** * PROBLEM DESCRIPTION: * * See Error description field for more information. * **************************************************************** * RECOMMENDATION: * * Upgrade to Version 9.5 FixPack 6. * **************************************************************** | |
Local-Fix: | |
Rewriting the query. The query can be rewritten by changing the long OR into a "IN (..,...,...)" predicate. E.g. change: select * from N where c1 = 1 OR c1 = 2 OR c2 = 3... to: select * from N where c1 IN (1,2,3...) | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in DB2 UDB Version 9.5 FixPack 6. | |
Workaround | |
see LOCAL FIX. | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC67775 IC67776 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 09.03.2010 22.06.2010 03.02.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP6 | |
Problem behoben lt. FixList in der Version |