|
Problem IT17699
|
Status: Closed |
DB2 INSTANCE MAY ABEND WHEN PREPARING A SQL QUERY |
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - 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 v11.1m1fp2 or Later. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
|
| Solution |
First Fixed in DB2 LUW v11.1m1fp2 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.10.2016
15.03.2018
15.03.2018 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
