DB2 - Problem description
Problem IT38829 | Status: Closed |
DB2 MIGHT ABEND WHEN RUNNING QUERIES CONTAINING CASE EXPRESSIONSAND SCALAR AGGREGATIONS | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
DB2 might trap when users run a query that has the following characteristics: 1. the query has multiple levels of SELECT 2. one of the lower level select lists has at least one CASE expression 3. the CASE expression contains scalar aggregations 4. the CASE expression is not referenced in higher level SELECT lists -------Frame------ ------Function + Offset------ 0x09000000467D194C sqlnd_qtb_pda__FRP9sqlnq_qtbT1iT3 + 0xAC 0x09000000467D2700 sqlnd_qtb_pda__FRP9sqlnq_qtbT1iT3 + 0xE60 0x09000000467D2700 sqlnd_qtb_pda__FRP9sqlnq_qtbT1iT3 + 0xE60 0x09000000467D2700 sqlnd_qtb_pda__FRP9sqlnq_qtbT1iT3 + 0xE60 0x09000000467D2700 sqlnd_qtb_pda__FRP9sqlnq_qtbT1iT3 + 0xE60 0x09000000467D2700 sqlnd_qtb_pda__FRP9sqlnq_qtbT1iT3 + 0xE60 0x09000000467D2700 sqlnd_qtb_pda__FRP9sqlnq_qtbT1iT3 + 0xE60 0x09000000467D1700 sqlnd_qtb_pda__FRP9sqlnq_qtbi + 0x80 0x09000000467D01F8 sqlnd_main__FP9sqlnq_quri + 0x378 0x0900000046D85308 sqlnr_after_prep1__FP10sqlnr_qrwaPiP14sqlnr_progress + 0x228 0x09000000468DB198 sqlnr_comp__FPiiP16sqlnr_rule_stateP10sqlnr_qrwaP14sqlnr_progres s + 0x218 0x09000000468DB544 sqlnr_seq__FPiP10sqlnr_qrwaP14sqlnr_progressP12sqlnr_rclass + 0xC4 0x09000000468DBA48 sqlnr_rcc__FiP10sqlnr_qrwaPiP14sqlnr_progress + 0x308 0x0900000046D86ADC sqlnr_exe__FP9sqlnq_qur + 0x6FC 0x09000000475DD3E4 sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq lrr_cmpl_enviT7PP9sql nq_qur + 0x7404 0x09000000475D5F68 sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq lrr_cmpl_env + 0x28 0x0900000046422F5C sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P14SQLP_ LOCK_INFOP16sqlra_cac hed_varPiT11_Pb + 0xBDC 0x0900000043DF4400 sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idUi T4PUcT4UsUcP14sqlra_c mpl_env15sqlra_fill_modePiiT12_N313_T12_P14SQLP_LOCK_INFOPP16sql ra_cached_varT12_bT19_Pb + 0xA60 0x090000004653329C sqlra_get_var__FP8sqlrr_cbiT2bPbT5 + 0xBFC 0x09000000453134FC sqlrr_prepare__FP14db2UCinterfaceP16db2UCprepareInfo + 0x57C 0x090000004A038DB0 sqljs_ddm_prpsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0x12B0 0x0900000049FC5610 sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC interface + 0x2B0 0x0900000049FC8664 sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + 0x2264 0x0900000049F94F9C IPRA.$sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0xE9C 0x0900000049F9D6B4 sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xB4 0x0900000049F93060 IPRA.$sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x13E0 0x0900000049F904B4 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 0x334 0x090000004325DBC0 RunEDU__8sqeAgentFv + 0xB60 0x0900000043240640 EDUDriver__9sqzEDUObjFv + 0x300 0x090000004312F614 sqloEDUEntry + 0x374 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5 FP7 or later * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5 FP7 or later * **************************************************************** | |
Comment | |
Upgrade to 11.5 FP7 or later | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 27.10.2021 22.11.2021 22.11.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |