DB2 - Problem description
Problem IT24841 | Status: Closed |
DB2 MIGHT TRAP WHEN EXECUTING COMPLEX QUERIES CONTAINING CSES | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
DB2 might trap when the following conditions are met: 1. a complex query contains multiple CSEs 2. there are predicates on the CSEs 3. DERPRD_FF is not set for DB2COMPOPT Crash stack: Stack #1 Signal #11 0 ossDumpStackTraceInternal 1 ossDumpStackTraceV98 2 OSSTrapFile::dumpEx 3 sqlo_trce 4 sqloEDUCodeTrapHandler 5 __waitpid 6 sqlnq_prd::replace_in_prdpderchd 7 sqlnq_prd::reassign_prdpder 8 sqlnq_prd::drop 9 sqlnq_opr::drop 10 sqlnq_qtb::box_drop_ts 11 sqlnq_mch::merge 12 sqlnq_som::merge_clear_wins 13 sqlnr_form_common_subexprs 14 sqlnr_optprep_chunk1 15 sqlnr_optprep_chunk1_action 16 sqlnr_comp 17 sqlnr_seq 18 sqlnr_rcc 19 sqlnr_exe 20 sqlnn_cmpl 21 sqlnn_cmpl 22 sqlra_compile_var 23 sqlra_find_var 24 sqlra_get_var 25 sqlrr_prepare 26 sqljs_ddm_prpsqlstt 27 sqljsParseRdbAccessed 28 sqljsParse 29 sqljsSqlam 30 sqljsDrdaAsInnerDriver 31 sqljsDrdaAsDriver 32 sqeAgent::RunEDU 33 sqzEDUObj::EDUDriver 34 sqloEDUEntry 35 _L_lock_3599 36 clone | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All Platforms * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 v10.5 Fixpack 10 or later. * **************************************************************** | |
Local Fix: | |
- Use the following OPTGUIDELINES: /* */ - Set the following: db2set -im DB2COMPOPT=NO_DERPRD_FF | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : IT22297 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 24.04.2018 16.07.2018 16.07.2018 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |