|
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) |
