IT30403: MEMORY CORRUPTION FROM OPTIMIZER JOIN STRUCT CREATION

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 is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels