|
Problem IT35256
|
Status: Closed |
DB2 TERMINATES ABNORMALLY COMPILING A QUERY.
|
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
When database configuration parameter STRING_UNITS is set to
CODEUNITS32.
Db2 may terminate abnormally with the following stack:
-------Frame------ ------Function + Offset------
0x09000001525D9478 sqlofmblkEx + 0x98
0x0900000156B0C5C0
sqlnq_encap_doit__FiP9sqlnq_pidPP9sqlnq_pidP12sqlnq_stringPUcP3l
ocC16SqlnqEncapPolicy + 0x680
0x09000001546C6A38
sqlnq_fun_res_walk__FP9sqlnq_pidP12sqlnq_stringPUcPP9sqlnq_pidP3
lociT6 + 0x1338
0x09000001546C5618
sqlnq_fun_tres__FP9sqlnq_pidP12sqlnq_stringPUcPP9sqlnq_pidP3loci
T6 + 0x198
0x0900000156A92068
sqlnq_sem_function_call__FPP8stknode_i10actiontypePUcP3loc +
0x1A28
0x09000001575B9064 sqlnp_smactn__FP8sqlnp_cbi + 0x424
0x09000001575B1640 sqlnp_parser__FP8sqlnp_cb + 0xAC0
0x0900000157586268
sqlnp_main__FP12sqlnq_stringbP3locPP9sqlnq_qur + 0xDA8
0x090000015750A334
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
lrr_cmpl_enviT7PP9sqlnq_qur + 0x8194
0x0900000157502128
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
lrr_cmpl_env + 0x28
0x090000015483255C
sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P14SQLP_
LOCK_INFOP16sqlra_cached_varPiT11_Pb + 0xBDC
0x09000001537684FC
sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idUi
T4PUcT4UsUcP14sqlra_cmpl_env15sqlra_fill_modePiiT12_N313_T12_P14
SQLP_LOCK_INFOPP16sqlra_cached_varT12_bT
0x0900000154824B94 sqlra_get_var__FP8sqlrr_cbiT2bPbT5 + 0xBF4
0x0900000153F8429C
sqlrr_prepare__FP14db2UCinterfaceP16db2UCprepareInfo + 0x57C
0x09000001593803B0
sqljs_ddm_prpsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0x12B0
0x090000015930AB90
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface + 0x2B0
0x090000015930DBD0
sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
0x2250
0x09000001592DA04C
IPRA.$sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0xEAC
0x09000001592E2B14
sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xB4
0x09000001592D80F0
IPRA.$sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x13F0
0x09000001592D5534 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T +
0x334
0x09000001526E0CA0 RunEDU__8sqeAgentFv + 0xB60
0x09000001526C37A0 EDUDriver__9sqzEDUObjFv + 0x2E0
0x09000001525B3714 sqloEDUEntry + 0x374 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to the latest fix pack. *
**************************************************************** |
| Local Fix: |
N/A |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to the latest fix pack. *
**************************************************************** |
| Comment |
Problem was first fixed in DB2 UDB Version 11.1 fix pack 6 |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 11.12.2020
19.03.2021
19.03.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
