Increase buffer pool size

Dear All, i found the following line in the message log of an IDS 10.00 on a Linux Box having 3GB memory: WARNING: Buffer pool size is too small for read ahead operation I would like to increase this parameter, as obviously it has the default size of 5000 buffers with a 2k page size. But how to do that? I found different answer on this, searching the documentation and the web. Can i change the value of the BUFFERPOOL entry in the onconfig file (and restart IDS)? Or do i have to change this using onparams? How to do that? Kind regards Marcus

Just go ahead and change it in the onconfig to what you want and then bounce the engine. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Marcus Delp Sent: Wednesday, September 14, 2011 6:47 AM To: ids@iiug.org Subject: Increase buffer pool size [24900] Dear All, i found the following line in the message log of an IDS 10.00 on a Linux Box having 3GB memory: WARNING: Buffer pool size is too small for read ahead operation I would like to increase this parameter, as obviously it has the default size of 5000 buffers with a 2k page size. But how to do that? I found different answer on this, searching the documentation and the web. Can i change the value of the BUFFERPOOL entry in the onconfig file (and restart IDS)? Or do i have to change this using onparams? How to do that? Kind regards Marcus ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Onparams is only used to add a new buffer pool for a pagesize that does not exist yet in preparation for adding a new dbspace with a new pagesize. Otherwise a buffer pool using the default BUFFERPOOL line setting is created. You have to edit the ONCONFIG file, change the BUFFERPOOL line for 2K pagesize, and bounce the instance. Art Art S. Kagel Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Wed, Sep 14, 2011 at 6:46 AM, Marcus Delp <marcus.delp@globit.com> wrote: > Dear All, > > i found the following line in the message log of an IDS 10.00 on a Linux > Box > having 3GB memory: > WARNING: Buffer pool size is too small for read ahead operation > > I would like to increase this parameter, as obviously it has the default > size of 5000 buffers with a 2k page size. But how to do that? I found > different answer on this, searching the documentation and the web. > > Can i change the value of the BUFFERPOOL entry in the onconfig file (and > restart IDS)? Or do i have to change this using onparams? How to do that? > > Kind regards > Marcus > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --90e6ba21219b1f332c04ace4ace3