Oninit cdi / Archive
Talk to an expert →

IFX_AUTOFREE

Posted in 2013

Topics: General Discussion

LUIS ROSA — — source: IIUG Forums & Mailing Lists

Hi, We are having a memory problem in IDS, because our applications are not freeing cursors memory. We try using IFX_AUTOFREE variable set to 1, and it works, but there are some cases where the application dumps (error 20481). We think that this happens because the cursor close but the prepare statement continues working. Is there another way to free cursor memory and avoid this problem? Thanks in advanced.

↪ replying to LUIS ROSA
Art Kagel — — source: IIUG Forums & Mailing Lists

Fix your applications? Art On Apr 4, 2013 8:11 AM, "LUIS ROSA" <lrosa@noanet.com.ar> wrote: > Hi, > > We are having a memory problem in IDS, because our applications are not > freeing cursors memory. We try using IFX_AUTOFREE variable set to 1, and it > works, but there are some cases where the application dumps (error 20481). > We > think that this happens because the cursor close but the prepare statement > continues working. Is there another way to free cursor memory and avoid > this > problem? Thanks in advanced. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --f46d04016b495d9be304d987eb16

↪ replying to Art Kagel
Alexandre Marini — — source: IIUG Forums & Mailing Lists

Hello. I should recommend you to ask your development team to always do the best practice "always close your open cursors, before closing your connection". Check this great article from Mr Mark Jamison: https://www.ibm.com/developerworks/mydeveloperworks/blogs/gbowerman/entry/always _close_your_cursors115 Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional Informix Senior DBA - Orizon Brasil BRIUG website administrator Informix independent consultant > To: ids@iiug.org > From: art.kagel@gmail.com > Subject: Re: IFX_AUTOFREE [29978] > Date: Thu, 4 Apr 2013 08:15:04 -0400 > > Fix your applications? > > Art > On Apr 4, 2013 8:11 AM, "LUIS ROSA" <lrosa@noanet.com.ar> wrote: > > > Hi, > > > > We are having a memory problem in IDS, because our applications are not > > freeing cursors memory. We try using IFX_AUTOFREE variable set to 1, and it > > works, but there are some cases where the application dumps (error 20481). > > We > > think that this happens because the cursor close but the prepare statement > > continues working. Is there another way to free cursor memory and avoid > > this > > problem? Thanks in advanced. > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --f46d04016b495d9be304d987eb16 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

↪ replying to LUIS ROSA
LUIS ROSA — — source: IIUG Forums & Mailing Lists

Thank you for your answers.

Related threads