DB2 - Problem description
Problem IT17689 | Status: Closed |
DB2 INSTANCE MAY ABEND WHEN PREPARING A SQL QUERY | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
DB2 may terminate abnormally when preparing a SQL query. An example stack trace seen in this scenario appears below: Stack Trace: ------FUNCTION------ ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm 0007F53C793457C ossDumpStackTraceV98 OSSTrapFile6dumpExEmiP7siginfoPvm 0007F53CDF72AB4 sqlo_trce 0007F53CDFFC4EC sqloEDUCodeTrapHandler sqlnq_qnc18field_value_locateERPhRiS2_ sqlnq_encap_doitiP9sqlnq_pidPS0_P12sqlnq_stringPhP3loc sqlnq_fun_res_walkP9sqlnq_pidP12sqlnq_stringPhPS0_P3locii sqlnq_fun_tresP9sqlnq_pidP12sqlnq_stringPhPS0_P3locii sqlnq_sem_function_callPP8stknode_i10actiontypePhP3loc sqlnp_smactnP8sqlnp_cbi sqlnp_parserP8sqlnp_cb sqlnp_mainP12sqlnq_stringbP3locPP9sqlnq_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: * * All Platforms * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 LUW v10.5 Fixpack 9 or Higher. * **************************************************************** | |
Local Fix: | |
Solution | |
This is first Fixed in DB2 LUW v10.5 Fixpack 9. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 27.10.2016 27.09.2017 27.09.2017 |
Problem solved at the following versions (IBM BugInfos) | |
9.0. | |
Problem solved according to the fixlist(s) of the following version(s) |