home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC67775 Status: Geschlossen

FEDERATED ONLY: TOO MANY OR PREDICATES MAY LEAD TO STACK EXHAUST ION AND
CRASHWHEN COMPILING THE QUERY

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - 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:                                         * 
* 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.                                          * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to V97 FP3                                           * 
****************************************************************
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.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
V97 FP3 included the fix. No behavior changes.
Workaround
set the agent size to a larger size
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
11.04.2010
16.09.2010
29.01.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP3
Problem behoben lt. FixList in der Version
9.7.0.3 FixList
9.7.0.3 FixList