Informix - Problem description
Problem IT30403 | Status: Closed |
MEMORY CORRUPTION FROM OPTIMIZER JOIN STRUCT CREATION | |
product: | |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 | |
Problem description: | |
Defect APAR IT22488, idsdb00514383 in 12.10.FC8 has been observed in 11.70.FC9 so the fix needs to be ported back to 11.70.FC9. 0x000000010009c14c (oninit)afstack 0x000000010009b620 (oninit)afhandler 0x000000010009b9dc (oninit)affail_interface 0x000000010009f314 (oninit)mt_ex_throw_sig@AF11_4 0x0000000100061f54 (oninit)afsig_handler 0x0000000100053d84 (oninit)add_to_list 0x0000000100052af0 (oninit)mt_shm_malloc_segid 0x0000000100051c28 (oninit)mt_malloc 0x00000001002348a0 (oninit)old_do_rualloc 0x0000000100235250 (oninit)chkralloc 0x0000000100480b14 (oninit)jl2jl 0x0000000101209ae0 (oninit)aj_mergejl 0x00000001012048ac (oninit)opjinit 0x00000001012025d0 (oninit)opdojoin 0x00000001011ffec8 (oninit)opjoin 0x000000010121c024 (oninit)op_join 0x000000010121d6e0 (oninit)op_phasejoin 0x000000010048baa0 (oninit)sqoptim 0x00000001002095e8 (oninit)bldstructs 0x0000000100204cc8 (oninit)IPRA.$sqcmd 0x0000000100208280 (oninit)sq_cmnd 0x0000000100208978 (oninit)sq_prepare 0x0000000100557edc (oninit)sqmain 0x0000000100c63964 (oninit)listen_verify 0x0000000100c628bc (oninit)spawn_thread 0x0000000100b14f44 (oninit)th_init_initgls 0x000000010161ecfc (oninit)startup Current SQL statement (102) : SELECT 'CNAME' AS ctr_gbn , NVL( SUM( NVL(x0.biztrip_day, 0)), 0) AS ctr_count , ROUND( NVL( SUM( NVL(x0.biztrip_day, 0)), 0) / '144' * 100, 2) AS ctr_rate FROM CtrOverCompn AS x0 JOIN CtrOver AS x1 ON x1.req_no = x0.req_no JOIN XomxIntfaTab AS x2 ON x2.req_no = x0.req_no AND x2.apr_state = 'XAD100' LEFT JOIN CtrOverRep AS x3 ON x3.biztrip_req_no = x1.req_no LEFT JOIN CtrOverRepCompn AS x4 ON x4.req_no = x3.rep_req_no AND x4.biztrip_psn_syspayno = x0.biztrip_psn_syspayno JOIN XomxIntfaTab AS x5 ON x5.req_no = x1.req_no AND x5.apr_state = 'XAD100' AND (x4.chng_clsf IS NULL OR x4.chng_clsf != '1') AND x0.biztrip_psn_syspayno = '20060001' AND x1.biztrip_start_ymd[1,4] = '2019' | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS version prior to 11.70.xC10. * **************************************************************** * PROBLEM DESCRIPTION: * * MEMORY CORRUPTION FROM OPTIMIZER JOIN STRUCT CREATION * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of IDS version prior to 11.70.xC10. * **************************************************************** * PROBLEM DESCRIPTION: * * MEMORY CORRUPTION FROM OPTIMIZER JOIN STRUCT CREATION * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Comment | |
Upgrade to IDS 11.70.xC9W2. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 25.09.2019 26.09.2019 31.08.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |