|
Problem IT06948
|
Status: Closed |
QUERY WILL MULTIPLE SUBSUMABLE SCALAR SUBQUERIES MAY CAUSE DB2 TO ABEND |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - 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: *
* Unknown *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Please upgrade to DB2 version 101 fix pack 5 *
**************************************************************** |
| Local Fix: |
Manually rewrite the query to pushdown the subquery to the
deepest subselect in the query. |
| Solution |
The fix is included in DB2 version 101 fix pack 5 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 04.02.2015
13.07.2015
13.07.2015 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.5
|
 |
