Shared Memory Problems, Informix IDS 7.31 install on SCO UnixWare 7.1.1

Hi All, First of all, here is what I am using: SCO UnixWare 7.1.1, IDS 7.3.1. My problem is with shared memory. I have set all of the settings according to the machine specific notes in the the release note except for this part: INFORMIX-OnLine Kernel Parameters: ================================= SEMMNI: 150 SEMMNS: 60 SEMMSL: 150 Where do these get set? I changed (as per IDS_7.3 in the release notes): SHMMNI 200 SHMSEG: 15 SHMMAX: 536870912 and rebuilt the kernel and they all check out using idtune -g <name>. The error I get in the online.log after onmonitor fails is: 15:46:18 shmat: [EMFILE][24]: out of shared memory segments, checksystem SHMSEG 15:46:18 mt_shm_init: can't create virtual segment Using ipcs and ipcrm I made sure that there were no blocks of shared memory left hanging around from previous attempts to initialize. I have read through the install docs and most of what is relevant on this group and, unless I missed something (which after the thousands of lines I have read here I am sure that I have) I am lost as to how to solve this. Any suggestions would be greatly appreciated. Thanks, John M mozurkewichj@mps.k12.mi.us

See my comments embedded: > Hi All, > First of all, here is what I am using: SCO UnixWare 7.1.1, IDS > 7.3.1. > My problem is with shared memory. I have set all of the settings > according to the machine specific notes in the the release note except > for this part: > > INFORMIX-OnLine Kernel Parameters: > ================================= > > SEMMNI: 150 > SEMMNS: 60 > SEMMSL: 150 > > Where do these get set? You would put this in file /etc/conf/cf.d/stune or use /etc/conf/bin/idtune to change it. On UW 7.1.3 these values are the default values as you can see at the bottom. > I changed (as per IDS_7.3 in the release notes): > SHMMNI 200 > SHMSEG: 15 > SHMMAX: 536870912 > > and rebuilt the kernel and they all check out using idtune -g <name>. > > The error I get in the online.log after onmonitor fails is: > > 15:46:18 shmat: [EMFILE][24]: out of shared memory segments, check> system SHMSEG > > 15:46:18 mt_shm_init: can't create virtual segment> > Using ipcs and ipcrm I made sure that there were no blocks of shared > memory left hanging around from previous > attempts to initialize. > I have read through the install docs and most of what is relevant on > this group and, unless I missed something (which after the thousands > of lines I have read here I am sure that I have) I am lost as to how > to solve this. > I found this SHM values in my stune: SHMMAX 2147483647 SHMMNI 200 SHMSEG 127 This is from mtune on UW 7.1.3: SEMMAP 0 0 0 %%INS%% SEMMNS 60 60 2500 %%INS%% SEMMNU 0 0 0 %%INS%% SEMMSL 150 25 300 %%INS%% SEMOPM 10 10 20 %%INS%% SEMUME 10 10 20 %%INS%% SEMVMX 32767 32767 32767 %%INS%% SEMAEM 16384 16384 16384 %%INS%% SHMMIN 1 1 1 %%INS%% SHMMAX 134217728 131072 2147483647 %%INS%% SHMMNI 4096 10 65536 %%INS%% SHMSEG 512 6 8192 %%INS%% SHMALL 512 256 2048 %%INS%% SEMMNI 150 10 10000 %%AUTO%% What are your settings for NETTYPE, BUFFERS and SHMVIRTSIZE ?

> What are your settings for NETTYPE, BUFFERS and SHMVIRTSIZE ? Here are the settings you requested. Through the IDS docs that I am using it says to make BUFFERS = 25000, I tried that but the problem still persists. NETTYPE ipcshm,1,13,NET BUFFERS 200SNVIRTSIZE 80000 Thanks, John M

I found this post, which you aparently wrote... everything works now. Thanks, John M You must tune kernel variable SHMMAX ! Default for SHMMAX is 128 kB on UW. Together with SHMSEG 6 you can create 6 shm-segments of 128 KB each. Increase SHMMAX to the max of 2147483647 and never think of it again: /etc/conf/bin/idtune SHMMAX 2147483647 Check the other by informix recommended values to (SHM..., SEM...). Then: /etc/conf/bin/idbuild -B shutdown -i6 -y

I found this post that you wrote... it took care of THAT problem anyway. Thanks, John M You must tune kernel variable SHMMAX ! Default for SHMMAX is 128 kB on UW. Together with SHMSEG 6 you can create 6 shm-segments of 128 KB each. Increase SHMMAX to the max of 2147483647 and never think of it again: /etc/conf/bin/idtune SHMMAX 2147483647 Check the other by informix recommended values to (SHM..., SEM...). Then: /etc/conf/bin/idbuild -B shutdown -i6 -y

John M wrote: > I found this post that you wrote... it took care of THAT problem anyway. > Thanks, > > John M > > > You must tune kernel variable SHMMAX ! > Default for SHMMAX is 128 kB on UW. Together with SHMSEG 6 you can > create 6 shm-segments of 128 KB each. > > Increase SHMMAX to the max of 2147483647 and never think of it again: > /etc/conf/bin/idtune SHMMAX 2147483647 > > Check the other by informix recommended values to (SHM..., SEM...). > > Then: > /etc/conf/bin/idbuild -B > shutdown -i6 -y But you said in your first post, you already increased SHMMAX and SHMSEG and build a new kernel an rebooted, if I remember correct. > I changed (as per IDS_7.3 in the release notes): > SHMMNI 200 > SHMSEG: 15 > SHMMAX: 536870912 15 * 536.870.912 = - 7.5 GB -> much more than you need for you informix config. ?????

John M schrieb: >>What are your settings for NETTYPE, BUFFERS and SHMVIRTSIZE ? > > > Here are the settings you requested. > Through the IDS docs that I am using it says to make BUFFERS = 25000, > I tried that but the problem still persists. > > NETTYPE ipcshm,1,13,NET > BUFFERS 200> SNVIRTSIZE 80000 > > Thanks, > John M what does onstat -g give you? Maybe your onconfig parameters are configured too low. We use SHMVIRTSIZE 500000 and SHMADD 65536 on a 1 GB RAM system. In my opinion your system tries to allocate more than 15 segments which isn't allowed due to the configuration of your stune file. Try to increase the SHMVIRTSIZE in your onconfig and see if it works. -- Roland Wintgen (Systemadministrator) EVG Elektro-Vertriebs-Gesellschaft Martens GmbH & Co KG Trompeterallee 244-246, D-41189 Moenchengladbach Tel. +49 21 66 / 55 08 23, Fax +49 21 66 / 55 08 90 www.evg.de rw@evg.de

"John M" <mozurkewichj@mps.k12.mi.us> wrote in message news:9d4c7934.0306241220.3071ff4b@posting.google.com... > Hi All, > First of all, here is what I am using: SCO UnixWare 7.1.1, IDS > 7.3.1. > My problem is with shared memory. I have set all of the settings > according to the machine specific notes in the the release note except > for this part: > http://www.smooth1.demon.co.uk/ifaq06.htm#6.7.3 Look at idtune bits!