increasing memory IDS11.50.FC3

hello all, We are increasing the RAM from 8Gb to 32Gb on the HP-UX 11.11 server.Just a quick question...should we be tuning informix to reflect the increase in memory? current settings are.... SHMVIRTSIZE 2784000#SHMADD 128000 SHMADD 256000 EXTSHMADD 8192 SHMTOTAL 10000000 Thanks in advance.

Hello, you should check how is your engine running with 8Gb, first. Eg: 1) check how many memory segments are you normally using? That should give you a great tip on how you could resize your SHM parameters (as least shm segments, better for you). 2) are you bufferpool enough for your concurrent sessions? check it out... then increase it, according to your new memory limits. 3) your SHMTOTAL parameter should be changed, of course.... Hope it helps. Best regards. Em 27/07/2011 11:43, howie.lfc@googlemail.com escreveu: > hello all, > > We are increasing the RAM from 8Gb to 32Gb on the HP-UX 11.11 > server.Just a quick question...should we be tuning informix to reflect > the increase in memory? > current settings are.... > > SHMVIRTSIZE 2784000> #SHMADD 128000 > SHMADD 256000 > EXTSHMADD 8192 > SHMTOTAL 10000000> > Thanks in advance. > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > -- Alexandre Marini Tecnologia da Informação - DBA msn: alexandre_marini@hotmail.com SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix <Cert-Info-Mgmt_color.jpg> IBM Certified System Administrator - Informix Dynamic Server V10 / V11 / V11.70 IBM Information Management Informix Technical Professional v3

"howie.lfc@googlemail.com" <howie.lfc@gmail.com> wrote in message news:b0a36222-0b2e-4bdf-98f8-8f003e163f0a@s2g2000vbw.googlegroups.com... > hello all, > > We are increasing the RAM from 8Gb to 32Gb on the HP-UX 11.11 > server.Just a quick question...should we be tuning informix to reflect > the increase in memory? > current settings are.... > > SHMVIRTSIZE 2784000> #SHMADD 128000 > SHMADD 256000 > EXTSHMADD 8192 > SHMTOTAL 10000000> > Thanks in advance. Generally you wouldn't change any of these unless you're changing the application and/or onstat -g seg shows that you already need multiple segments. I'm guessing you don't have issues here since you already have SHMTOTAL set to more memory than you have in the box. The most likely things you would change to exploit extra memory, all else being equal, would be BUFFERS. If you are on Workgroup/Growth edition you cannot allocate more than a total of 16g to any one instance anyway, and to stay within the Informix rules you should limit the allocation across ALL instances on the server to 16g.