home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
14.10.xC11 FixList
12.10.xC16.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

Informix - Problem description

Problem IC61332 Status: Closed

SYSMASTER:SYSENVSES QUERY CORRUPTS MEMORY

product:
IBM IDS ENTRP E / 5724L2304 / B15 - IDS 11.50
Problem description:
A query on sysmaster:sysenvses like 
 
  select envses_name, envses_value from sysmaster:sysenvses 
  where envses_sid = ? 
 
corrupts the server's memory. This stays mostly undetected. But 
some 
queries containing group by, hash joins or sorts are sensitive 
to this 
and can abend the server: 
 
0x0000000100065210 (oninit)afstack 
0x000000010005df00 (oninit)mt_ex_throw_sig 
0x000000010004aa9c (oninit)afsig_handler 
0x000000010097e3d4 (oninit)hash_nextgrprow 
0x07000000ac69a930 (*nosymtab*)0x7000000ac69a930 
0x0000000100981578 (oninit)unordered_group_by_next 
.... 
 
0x0000000100065210 (oninit)afstack 
0x000000010005df00 (oninit)mt_ex_throw_sig 
0x000000010004aa9c (oninit)afsig_handler 
0x00000001000d5718 (oninit)ldlong 
0x0000000000000000 (*nosymtab*)0x0 
0x0000000000000000 (*nosymtab*)0x0 
0x0000000100428464 (oninit)srtcompare 
0x00000001004309a0 (oninit)srtquick_90_7 
0x0000000100429c04 (oninit)psrtloop 
0x0000000100b7c5ec (oninit)startup
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users querying the sysmaster tables sysenvses or sysenv      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Querying sysmaster tables sysenvses or sysenv corrupted one  * 
* byte of memory, which in some cases could lead to a failure  * 
* and server shutdown later on.                                * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to 11.50.xC5 and above.                              * 
****************************************************************
Local Fix:
Solution
Problem first fixed in IDS 11.50.xC5.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
02.06.2009
19.01.2010
19.01.2010
Problem solved at the following versions (IBM BugInfos)
11.50.xC5
Problem solved according to the fixlist(s) of the following version(s)
11.50.xC5 FixList