DB2 - Problem description
Problem IT24567 | Status: Closed |
DB2 MAY ABEND WHILE COMPILING A QUERY CONTAINING COMMON-TABLE-EXPRESSIONS | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
DB2 may terminate abnormally when compiling a query that contains common-table-expressions. An example stack trace is seen below: ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm ossDumpStackTraceV98 OSSTrapFile6dumpExEmiP7siginfoPvm sqlo_trce sqloEDUCodeTrapHandler sqlnoSmpDetermineDegreeP20SQLNO_SMP_POSTOPT_CBP9sqlnq_qurP19sqln o_plan_operator sqlnoSmpPostPassMain sqlno_final_phaseP13sqlno_globals sqlno_exeP9sqlnq_qur sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sqlrr_ cmpl_env sqlra_compile_varP8sqlrr_cbP14sqlra_cmpl_envPhitiiiiiP14SQLP_LOC K_INFOP16sqlra_cached_varPiS5_Pb sqlra_find_varP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idjjPhj thP14sqlra_cmpl_env15sqlra_fill_modePiiS8_iiiS8_P14SQLP_LOCK_INF OPP16sqlra_cached_varS8_bSA_Pb sqlra_get_varP8sqlrr_cbiibPbS1_ sqlrr_prepareP14db2UCinterfaceP16db2UCprepareInfo sqljs_ddm_prpsqlsttP14db2UCinterfaceP13sqljDDMObject sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UCint erface sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T sqeAgent6RunEDUEv sqzEDUObj9EDUDriverEv sqloEDUEntry clone | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * db2 luw server * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * upgrade fixpak * **************************************************************** | |
Local Fix: | |
N/A | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : follow-up : IT24568 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 28.03.2018 10.03.2019 10.03.2019 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |