|
Problem IC62891
|
Status: Closed |
COMPILING A QUERY CAUSES DB2 INSTANCE TO TERMINATE ABNORMALLY DU ETO STACK OVERFLOW |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
A query consisting of a union of two or more tables with a large
number of constraints may cause the DB2 server to terminate
abnormally.
db2diag reports:
2008-10-30-16.26.32.399012+480 E8589952A623 LEVEL: Severe
PID : 581798 TID : 2572 PROC : db2sysc
0
INSTANCE: cdbsy NODE : 000 DB : CCPMP
APPHDL : 0-284 APPID: *LOCAL.cdbsy.081030082600
AUTHID : SYDTAOWN
EDUID : 2572 EDUNAME: db2agent (CCPMP) 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.
2008-10-30-16.26.32.399624+480 E8590576A464 LEVEL: Severe
PID : 581798 TID : 2572 PROC : db2sysc
0
INSTANCE: cdbsy NODE : 000 DB : CCPMP
APPHDL : 0-284 APPID: *LOCAL.cdbsy.081030082600
AUTHID : SYDTAOWN
EDUID : 2572 EDUNAME: db2agent (CCPMP) 0
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler,
probe:40
DATA #1 : <preformatted>
Current stack size = 4194304
2008-10-30-16.26.32.578634+480 E8591041A549 LEVEL: Severe
PID : 643150 TID : 258 PROC : db2wdog
0
INSTANCE: cdbsy NODE : 000
EDUID : 258 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.
Stack produced in this case :
sqlnq_build_interval_list__FP9sqlnq_pidT1RP18sqlnq_intervalListP
3loc + 0x508
sqlnq_build_interval_list__FP9sqlnq_pidT1RP18sqlnq_intervalListP
3loc + 0x508
sqlnq_prepare_prd_compare__FP9sqlnq_pidRP9sqlnq_pidRP18sqlnq_int
ervalListP3loc + 0x324
sqlnr_ua_find_partcol__FPP9sqlnq_pidiT1CP3loc + 0x258
sqlnr_ua_prove_disjoint__FP9sqlnq_oprCP3locCi + 0x1188
sqlnr_qrwprep_phase1__FP3loc + 0x1910 |
| Problem Summary: |
Compiling a query causes DB2 instance to terminate abormally due
to stack overflow |
| Local Fix: |
Reduce the optimization level from 5 to 3 |
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
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 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 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 10 for Linux, UNIX, and Windows
|
| Solution |
First Fixed in V9.7 FP1 |
| Workaround |
N/A |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 02.09.2009
02.03.2010
02.03.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
