Bufferpool max size in Windows Server 2008 64bit

Hi, I am installing Informix 11.70 for a DW. On my Windows Server 2008 (64bit) I have 64GB memory and I am trying to take advantage of it. I have set the following bufferpool sizes and restarted the engine, but my parameters are not respected and the actual values are much lower. Is there some max size for the bufferpools? If not, is there any downside to specifying very large bufferpools? Thanks, Lauri Pietarinen BUFFERPOOL default,buffers=10000,lrus=8,lru_min_dirty=50.00,lru_max_dirty=60.50 BUFFERPOOL size=4K,buffers=3000000,lrus=8,lru_min_dirty=50.00,lru_max_dirty=60.00 BUFFERPOOL size=16K,buffers=2000000,lrus=8,lru_min_dirty=50.00,lru_max_dirty=60.50 d:\\\\Program Files\\\\IBM\\\\Informix\\\\11.70>onstat -X IBM Informix Dynamic Server Version 11.70.FC5 -- On-Line -- Up 17:34:01 --12682 048 Kbytes Buffers (Access) address owner flags pagenum memaddr nslots pgflgs scount waiter Buffer pool page size: 4096 0 modified, 1000000 total, 1048576 hash buckets, 4096 buffer size Buffer pool page size: 16384 0 modified, 500000 total, 524288 hash buckets, 16384 buffer size d:\\\\Program Files\\\\IBM\\\\Informix\\\\11.70>

Are there any messages about the buffer pool or memory allocation in the message log when you start up 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, Nov 14, 2012 at 4:30 AM, LAURI PIETARINEN < lauri.pietarinen@relational-consulting.com> wrote: > Hi, > > I am installing Informix 11.70 for a DW. On my Windows Server 2008 (64bit) > I > have 64GB memory and I am trying to take advantage of it. > > I have set the following bufferpool sizes and restarted the engine, but my > parameters are not respected and the actual values are much lower. > > Is there some max size for the bufferpools? > > If not, is there any downside to specifying very large bufferpools? > > Thanks, > Lauri Pietarinen > > BUFFERPOOL > default,buffers=10000,lrus=8,lru_min_dirty=50.00,lru_max_dirty=60.50 > BUFFERPOOL > size=4K,buffers=3000000,lrus=8,lru_min_dirty=50.00,lru_max_dirty=60.00 > BUFFERPOOL > size=16K,buffers=2000000,lrus=8,lru_min_dirty=50.00,lru_max_dirty=60.50> > d:\\\\Program Files\\\\IBM\\\\Informix\\\\11.70>onstat -X > > IBM Informix Dynamic Server Version 11.70.FC5 -- On-Line -- Up 17:34:01 --> 12682 > 048 Kbytes > > Buffers (Access) > address owner flags pagenum memaddr nslots > pgflgs scount waiter > > Buffer pool page size: 4096 > 0 modified, 1000000 total, 1048576 hash buckets, 4096 buffer size > > Buffer pool page size: 16384 > 0 modified, 500000 total, 524288 hash buckets, 16384 buffer size > > d:\\\\Program Files\\\\IBM\\\\Informix\\\\11.70> > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --f46d0401f5915fe9a104ce729bc8

Hello. It seems you are changing some different onconfig file. Could you post your complete version number? "onstat -" output? (In case you are running some limited one, you might be hitting memory limits). Look for environment variables, for ONCONFIG. If there is one value for this, you must change that one, not the one you mentioned, in order to Informix recognize it. There is no soft limit for BUFFERPOOLs, only physical ones. 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: lauri.pietarinen@relational-consulting.com > Subject: Bufferpool max size in Windows Server 2008 64bit [28823] > Date: Wed, 14 Nov 2012 04:30:09 -0500 > > Hi, > > I am installing Informix 11.70 for a DW. On my Windows Server 2008 (64bit) I > have 64GB memory and I am trying to take advantage of it. > > I have set the following bufferpool sizes and restarted the engine, but my > parameters are not respected and the actual values are much lower. > > Is there some max size for the bufferpools? > > If not, is there any downside to specifying very large bufferpools? > > Thanks, > Lauri Pietarinen > > BUFFERPOOL > default,buffers=10000,lrus=8,lru_min_dirty=50.00,lru_max_dirty=60.50 > BUFFERPOOL > size=4K,buffers=3000000,lrus=8,lru_min_dirty=50.00,lru_max_dirty=60.00 > BUFFERPOOL > size=16K,buffers=2000000,lrus=8,lru_min_dirty=50.00,lru_max_dirty=60.50> > d:\\\\Program Files\\\\IBM\\\\Informix\\\\11.70>onstat -X > > IBM Informix Dynamic Server Version 11.70.FC5 -- On-Line -- Up 17:34:01 --> 12682 > 048 Kbytes > > Buffers (Access) > address owner flags pagenum memaddr nslots > pgflgs scount waiter > > Buffer pool page size: 4096 > 0 modified, 1000000 total, 1048576 hash buckets, 4096 buffer size > > Buffer pool page size: 16384 > 0 modified, 500000 total, 524288 hash buckets, 16384 buffer size > > d:\\\\Program Files\\\\IBM\\\\Informix\\\\11.70> > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Hi, I restarted engine once more and now it looks right. So, probable user error! Are there other memory parameters that would benefit from very large values? Thanks, Lauri d:\\\\Program Files\\\\IBM\\\\Informix\\\\11.70>onstat -X IBM Informix Dynamic Server Version 11.70.FC5 -- On-Line -- Up 00:05:20 --46170 176 Kbytes Buffers (Access) address owner flags pagenum memaddr nslots pgflgs scount waiter Buffer pool page size: 4096 0 modified, 3000000 total, 4194304 hash buckets, 4096 buffer size Buffer pool page size: 16384 0 modified, 2000000 total, 2097152 hash buckets, 16384 buffer size

Hi Lauri, You may also want to check what size your resident memory segment is. With 16GB ram on windows server 2008 r2 (I was only using informix growth edition so may have behaved differently or had a different initial configuration) I found the resident segment was initially limited to the difference between the starting address and the address where system dll's loaded - usually around 2 or 3 GB, the rest of the buffers all got assigned to multiple virtual segments (onstat -g seg). System dll's are at around 4GB and oninit.exe loaded around 5GB. So, if you are getting a large number of virtual segments try setting the base address above all this (SHMBASE 0x141460000L) and potentially exclude the system and oninit memory spaces (SHMNOACCESS 0x7707FFFF-0x77800000,0x140000000-0x141480000). But this may not be an issue for you, posted this here in case someone else searches on a similar problem :-) Regards, Bryce Stenberg.