|
Problem IT06592
|
Status: Closed |
QUERY WITH MULTIPLE SUBSUMABLE SCALAR SUBQUERIES MAY CAUSE DB2 TO ABEND |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Under rare conditions, DB2 might abend if the following
conditions are satisfied
1) The query contains two or more scalar subqueries
2) Atleast 2 subqueries can be proven to be subsumed by each
other and can only be executed once
3) Atleast one of these subqueries is used in a predicate
4) One or more of these subqueries are part of the output column
list.
Similar stack will be dumped in the trap file:
sqlnr_matchmaker::nav_assign_max_levels
sqlnr_matchmaker::nav_assign_max_levels
sqlnr_matchmaker::nav_assign_max_levels
sqlnr_matchmaker::nav_init
sqlnr_matchmaker::form_matches
sqlnr_form_common_subexprs
sqlnr_optprep
sqlnr_optprep_action
sqlnr_comp
sqlnr_seq
sqlnr_rcc
sqlnr_exe
sqlnr_exe
sqlnn_cmpl
sqlnn_cmpl
sqlra_compile_var
sqlra_find_var
sqlra_get_var
sqlrr_prepare
sqljs_ddm_prpsqlstt
sqljsParseRdbAccessed
.sqljsParse.fdpr.clone.45__FP13sqljsDrdaAsCbP14db2UCinterfaceP8s
qeAgentb
sqljsSqlam
sqljsDriveRequests
sqljsDrdaAsInnerDriver
sqljsDrdaAsDriver
sqeAgent::RunEDU
sqzEDUObj::EDUDriver
sqloEDUEntry |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 970 fixpack 11 *
**************************************************************** |
| Local Fix: |
Manually rewrite the query to pushdown the subquery to the
deepest subselect in the query. |
| Solution |
The fix was delivered in DB2 version 970 fixpack 11 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 19.01.2015
21.10.2015
21.10.2015 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.0
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.11
|
 |
