shared memory issue

Hi I am frequently getting below error, I know I am using workgroup Edition hence there is a limit, Using shared memory... however transaction are so less hence dont expect this error very frequently Warning: The IBM IDS Growth Edition license restriction limits the total shared memory size for this server to 16777216 KB. Size of resident + virtual segments 5392908 KB + 11776000 KB > 16777216 KB. The out of shared memory error has been encountered 5 times since it was last printed to the log. out of virtual shared memory Any help will be appreciated! Thanks

As you know, workgroup edition has a 16 GB limit on shared memory. What is happening is that Informix wants to add another virtual memory segment for some reason, and the addition of that new segment would push you over the memory limit. What does "onstat -g seg" show you? Do you have a lot of memory segments added already? Perhaps the size of additional memory segments (SHMADD) has been set too large? Perhaps something is hanging on to memory and not releasing it? What version of Informix are you using? Most likely you'll need to find out what is running that is trying to grab more virtual memory. Mike Walker Advanced DataTools Corporation -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of J SHA Sent: Thursday, October 01, 2015 11:09 AM To: ids@iiug.org Subject: shared memory issue [35811] Hi I am frequently getting below error, I know I am using workgroup Edition hence there is a limit, Using shared memory... however transaction are so less hence dont expect this error very frequently Warning: The IBM IDS Growth Edition license restriction limits the total shared memory size for this server to 16777216 KB. Size of resident + virtual segments 5392908 KB + 11776000 KB > 16777216 KB. The out of shared memory error has been encountered 5 times since it was last printed to the log. out of virtual shared memory Any help will be appreciated! Thanks **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

You should always post your platform and Informix version details so you don't have to wade through version specific answers that do not apply to you. Here's mine for you: If you are running any later v11.50, any 11.70, or v12.10 earlier than 12.10.xC5W1 there are at least three memory leak bugs that were fixed in 12.10.xC5W1 and a patch release of 11.70 (I don't remember what the patch version # is and I don't know if any fix is available for 11.50 on short notice). V11.50 and 11.70 also suffer from a bug that uses up file handles and memory as well under specific conditions that is fixed in an early 12.10 release and the latest v11.70 release. In addition to that, if you are running v11.70 or 12.10 and have VP_MEMORY_CACHE_KB set without the "STATIC" option (the "DYNAMIC" alternative is the default in 11.70 and 12.10 STATIC was the only behavior in 11.50) then the DYNAMIC VP memory cache behavior may be stealing memory and triggering additional shared memory segments to be allocated to replace it. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Oct 1, 2015 at 1:09 PM, J SHA <shadaisy08@gmail.com> wrote: > Hi > > I am frequently getting below error, I know I am using workgroup Edition > hence > there is a limit, Using shared memory... however transaction are so less > hence > dont expect this error very frequently > > Warning: The IBM IDS Growth Edition license restriction limits > the total shared memory size for this server to 16777216 KB. > Size of resident + virtual segments 5392908 KB + 11776000 KB > 16777216 KB. > The out of shared memory error has been encountered 5 times since it was > last > printed to the log. > out of virtual shared memory > > Any help will be appreciated! > > Thanks > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --e89a8f839e938fc27f05210fee41

onstat -g afr /onstat -g mem. Which pools/sessions are taking up the memory? Regards, David. > On 01 October 2015 at 20:19 Art Kagel <art.kagel@gmail.com> wrote: > > > You should always post your platform and Informix version details so you > don't have to wade through version specific answers that do not apply to > you. > > Here's mine for you: If you are running any later v11.50, any 11.70, or > v12.10 earlier than 12.10.xC5W1 there are at least three memory leak bugs > that were fixed in 12.10.xC5W1 and a patch release of 11.70 (I don't > remember what the patch version # is and I don't know if any fix is > available for 11.50 on short notice). V11.50 and 11.70 also suffer from a > bug that uses up file handles and memory as well under specific conditions > that is fixed in an early 12.10 release and the latest v11.70 release. > > In addition to that, if you are running v11.70 or 12.10 and have > VP_MEMORY_CACHE_KB set without the "STATIC" option (the "DYNAMIC" > alternative is the default in 11.70 and 12.10 STATIC was the only behavior > in 11.50) then the DYNAMIC VP memory cache behavior may be stealing memory > and triggering additional shared memory segments to be allocated to replace > it. > > Art > > Art S. Kagel, President and Principal Consultant > ASK Database Management > www.askdbmgt.com > > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on the IIUG, nor any other organization with which I am > associated either explicitly, implicitly, or by inference. Neither do > those opinions reflect those of other individuals affiliated with any > entity with which I am affiliated nor those of the entities themselves. > > On Thu, Oct 1, 2015 at 1:09 PM, J SHA <shadaisy08@gmail.com> wrote: > > > Hi > > > > I am frequently getting below error, I know I am using workgroup Edition > > hence > > there is a limit, Using shared memory... however transaction are so less > > hence > > dont expect this error very frequently > > > > Warning: The IBM IDS Growth Edition license restriction limits > > the total shared memory size for this server to 16777216 KB. > > Size of resident + virtual segments 5392908 KB + 11776000 KB > 16777216 KB. > > The out of shared memory error has been encountered 5 times since it was > > last > > printed to the log. > > out of virtual shared memory > > > > Any help will be appreciated! > > > > Thanks > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --e89a8f839e938fc27f05210fee41 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

checking 'onstat -g mem' was already mentioned in one of the other responses. Consider collecting this output in intervals after this Informix instance was started. Then you should be able to see if there is a specific memory pool which grows constantly, for example. Also, this output will be helpful if you involve technical support by opening a PMR.

Thanks all for suggestions, though still getting error version is 11.70.FC6GE