INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70

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'

****************************************************************
* USERS AFFECTED:                                              *
* Users of IDS version prior to 11.70.xC10.                    *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* MEMORY CORRUPTION FROM OPTIMIZER JOIN STRUCT CREATION        *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************

****************************************************************
* USERS AFFECTED:                                              *
* Users of IDS version prior to 11.70.xC10.                    *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* MEMORY CORRUPTION FROM OPTIMIZER JOIN STRUCT CREATION        *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************

Upgrade to IDS 11.70.xC9W2.

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

25.09.2019
26.09.2019
31.08.2020