APAR status
Closed as fixed if next.
Error 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'
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * Users of IDS version prior to 11.70.xC10. * **************************************************************** * PROBLEM DESCRIPTION: * * MEMORY CORRUPTION FROM OPTIMIZER JOIN STRUCT CREATION * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
Upgrade to IDS 11.70.xC9W2.
Temporary fix
Comments
APAR Information
APAR number
IT30403
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
B70
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-09-25
Closed date
2019-09-26
Last modified date
2024-09-24
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B70","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
25 September 2024