DB2 - Problem description
Problem IT32731 | Status: Closed |
DB2 SERVER MAY TERMINATE ABNORMALLY WITH AN UPDATE QUERY | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
An update query with joining tables may cause the server to terminate abnormally. Below is an example of the trap stack: _Z31sqlnq_expand_inline_scalar_fcnsPP8stknode_i10actiontypePhP3l oc _Z12sqlnp_smactnP8sqlnp_cbi _Z12sqlnp_parserP8sqlnp_cb _Z10sqlnp_mainP12sqlnq_stringbP3locPP9sqlnq_qur _Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq lrr_cmpl_enviiPP9sqlnq_qur _Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq lrr_cmpl_env _Z17sqlra_compile_varP8sqlrr_cbP14sqlra_cmpl_envPhitiiiiiP14SQLP _LOCK_INFOP16sqlra_cached_varPiS5_Pb _Z14sqlra_find_varP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idj jPhjthP14sqlra_cmpl_env15sqlra_fill_modePiiS8_iiiS8_P14SQLP_LOCK _INFOPP16sqlra_cached_varS8_bSA_Pb _Z13sqlra_get_varP8sqlrr_cbiibPbS1_ _Z23sqlrr_execute_immediateP8sqlrr_cbi _Z14sqlrr_execimmdP14db2UCinterfaceP16db2UCprepareInfo _Z19sqljs_ddm_excsqlimmP14db2UCinterfaceP13sqljDDMObject _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U Cinterface _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T _ZN8sqeAgent6RunEDUEv _ZN9sqzEDUObj9EDUDriverEv sqloEDUEntry | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 v11.5.4.0 or higher * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 04.05.2020 30.06.2020 12.11.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |