IBM Support

IT30403: MEMORY CORRUPTION FROM OPTIMIZER JOIN STRUCT CREATION

Subscribe

You can track all active APARs for this component.

 

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

    2020-08-31

  • 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":"BU029","label":"Software"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B70"}]

Document Information

Modified date:
01 September 2020