Re: IS NULL memory leak

jregep@venus.vrx.vhi.com (John Regep) wrote: >Hi All! >Any one heard of this? >STATS: >HP 9000 T600 & K450 >HP/UX 10.2 >Informix ODS 7.23 >Informix 4GL 6.X >When using the "IS NULL" clause in a prepared select statment, then executing >the statment, a memory leak is created. Comment? >We are trying to move to this new platform and this is a major stumbling block. >Informix keeps saying they will fix it in 2 or 3 weeks but its been 6 already. >Thy say its not on their known bug list, I can't believe that we are th only >ones with this problem. Anyone else seen this? >Thanks a lot, >John Regep >Director Retail Development >Value Rx, Inc. >regepj@venus.vrx.vhi.com >PS Please respond to be directly as I am no longer on the general news group. >PSS To all my Informix freinds out there... hope you have a great new year. >See you in Seattle! Have Informix research bug id 85816, and see if it pertains to you. It's a recent bug that was assigned within the last 45 days that we came across on our system and involves a very specific type statement involving null on an indexed column. Fortunatley or unfortunately for us, it brought our system to it's knees. However, this allowed us to treat it as a down system and we received a patch within a couple of days. By the way, our system specifics are as follows: Sun Sparcenter 2000e Solaris 2.6 Informix 7.14ud5x3(2 patches incorporated specific to us) Two final notes. Apparently this bug has been around forever, going back as far as version 5 engines. However, it did not impact us until we upgraded our operating system from Solaris 2.4 to 2.6. Second, we are also seeing a potential memory leak on an different system. This system is also running informix 7.14ud1(unpatched) on an HP k400 running HPUX 10.01. The system is running a PeopleSoft HR application. What we see are sessions that continually grap memory as user do data entry. The memory does not free until they log off. The specific memory type is ralloc. We have not identified the leak yet, but there are some similarities with the bug mentioned above. Fortunately, we have 1 gig of memory on this system, and the system has handled the leak so far. Barry Leb National Linen Service 1420 Peachtree Street MS #314 Atlanta, GA 30309 (404) 853-6119 (404) 853-6485 fax e-mail: barryleb@mindspring.com