|
Problem IC88092
|
Status: Closed |
DB2 MIGHT ABEND WHILE COMPILING QUERY WITH MULTIPLE OUTER JOINS AND IS NULL PREDICATE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Under rare scenarios, DB2 might abend if the following
conditions are true:
1. The query has atleast two left or right joins.
2. There are one or more IS NULL predicates in the where clause
3. The IS NULL predicate references table from the null
producing side of the left join
4. The left join above has more than one join predicate defined
in the on-clause
5. One of more predicates references columns from the null
producing side of the second left join.
<Stack Trace>
0 ossDumpStackTraceEx
1 OSSTrapFile::dumpEx
2 sqlo_trce
3 sqloEDUCodeTrapHandler
4 __pthread_mutex_cond_lock
5 sqlno_project_end_prd
6 sqlno_call_sf
7 sqlno_each_prd
8 sqlno_call_sf
9 sqlno_each_opr
10 sqlno_call_sf
11 sqlno_each_qur
12 sqlno_call_sf
13 sqlno_scan_qgm
14 sqlno_dpd
15 sqlno_prep_phase
16 sqlno_exe
17 sqlnn_cmpl
18 sqlnn_cmpl
19 sqlra_compile_var
20 sqlra_find_var
21 sqlra_get_var
22 sqlrr_prepare
23 sqljs_ddm_prpsqlstt
24 sqljsParseRdbAccessed
25 sqljsParse
26 sqljsSqlam
27 sqljsDriveRequests
28 sqljsDrdaAsInnerDriver
29 sqljsDrdaAsDriver
30 sqeAgent::RunEDU
31 sqzEDUObj::EDUDriver
32 sqlzRunEDU
33 sqloEDUEntry
34 pthread_create@@GLIBC_2.2.5
35 clone |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix pack 8. *
**************************************************************** |
| Local Fix: |
db2set DB2COMPOPT=327685,268435456 and restart instance |
| available fix packs: |
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
|
| Solution |
First fixed in DB2 Version 9.7 Fix pack 8. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC88127 IC88128
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 08.11.2012
01.04.2013
01.04.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.8
|
 |
