IFX_AUTOFREE
Luis Rosa reported cursor memory not being freed in IDS; IFX_AUTOFREE=1 helped, but some applications dumped with error 20481. Art Kagel answered to fix the applications. Alexandre Marini advised always closing open cursors before closing the connection and cited an article on the subject. Luis thanked them; no engine-side alternative was offered.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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.
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
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. >
Thank you for your answers.