Re: How to use more than 2GB share memory in Informix?

Set it to 0. I always do. From: hanna_shaw@my-deja.com > >Thanks, Greg. Now I have some idea about it. I did set SHMMAX to 4G. >Now I'm thinking that it's SHMTOTAL in onconfig which causes the >problem. I once set SHMTOTAL to 3GB. But when I tried to restart >Informix, it failed with an error: >size of resident + virtual segments xxx + yyy > 500MB total allowed by >configuration parameter SHMTOTAL > >(I can't remember the message very clearly.) It seems that Informix >can't recognize any number greater than 2GB. So I have to set SHMTOTAL >to 2GB again. I think there will be no problem to use more than 2GB if >I set it to 0. Do you know what's the default SHMTOTAL if it's 0 in >onconfig? What will happen if it gets to 3.75GB? Is there any potential >problem to set it to 0? I heard it's not good to set it to 0. But I >don't know the reason. > >In article ><B875AB35CDD648B7.AA29810C93EA172D.1412DA64A6086D05@lp.airnews.net>, > Greg <greg@fastlane.xnet> wrote: > > On 32 bit solaris ports (which you have - UC4...) the limit for >BUFFERS is > > 768K, *not* 512K.> > The max shared memory you can use is 3.75GB. Set SHMMAX at the OS >level to > > 4000000000 and forget about it. Then set BUFFERS <=768000, >SHMVIRTSIZE to> > something big (Like 1024000 (= 1GB), and SHMADD to something pretty >big as > > well, say 256000. You should then be OK until you hit the 3.75GB >limit. > > I've done it and it works. > > > > If that isn't enough, then upgrade to solaris 7 or 8 (2.7 or 2.8 >depending on > > your perspective...), and upgrade to a 64 bit Informix port (i.e. >7.31.FCn), > > and you should be able to use all the memory you can afford to buy. > > > > Moving to another DBMS won't help, but it will waste your time and >money. > > > > Greg > > > > p.s. are these connections persistent, or do they come and go >regularly? > > > > Phillip wrote: > > > > > The max limit for BUFFERS is 512000, so you can try setting your >parameter > > > to that as long as you have enough physical memory. > > > > > > hanna_shaw@my-deja.com wrote: > > > > > > > Hi, > > > > > > > > I know that there is a limit for share memory in Informix. Our >project > > > > just launched recently. We have 400 user sessions right now. They >eat > > > > up about 1GB virtual memory. Including 400,000 buffers, the total >used > > > > share memory almost gets to the 2GB limit. We will have about >2000 user > > > > sessions at the beginning of next year. What should I do? Is >there any > > > > method to use more than 2GB memory in Informix? Or we have to >move to > > > > other DBMS? Thanks for your attention. > > > > > > > > Btw, our Informix version is IDS7.31.uc4. > > > > > > >Sent via Deja.com http://www.deja.com/ >Before you buy. _____________________________________________________________________________________ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com