• Admin-Scout-small-Banner
           
    CURSOR Admin-Scout
    get the ultimate tool for Informix
    pfeil  
invispix 10x10
invispix 10x10
Latest versionsfixlist
14.10.xC5 FixList
12.10.xC14.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26
Question in the chat LiveZilla Live Help

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
not known / see Local fix
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)
invispix 10x10
invispix 10x10
invispix 10x10
Technical InfoTechnical Info

Technical Info

DocumentationDocumentation

Documentation

IBM NewsletterIBM Newsletter

IBM Newsletter

Current BugsCurrent Bugs

Current Bugs

Bug ResearchBug Research

Bug Research

Bug FixlistsBug Fixlists

Bug Fixlists

Release NotesRelease Notes

Release Notes

Machine NotesMachine Notes

Machine Notes

Release NewsRelease News

Release News

Product LifecycleProduct Lifecycle

Lifecycle

Media DownloadMedia Download

Media Download

invispix 10x10
Service und SupportService und Support

Service and Support

Informix MonitoringInformix Monitoring

Informix Monitoring

Admin-Scout forInformixAdmin-Scout forInformix

Admin-Scout for Informix

Informix News & InfosInformix News & Infos

Informix News & Infos

This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.