dbTalk Databases Forums  

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

comp.databases.informix comp.databases.informix


Discuss Shared Memory Problems, Informix IDS 7.31 install on SCO UnixWare 7.1.1 in the comp.databases.informix forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
John M
 
Posts: n/a

Default Shared Memory Problems, Informix IDS 7.31 install on SCO UnixWare 7.1.1 - 06-24-2003 , 04:20 PM






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, 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.

Any suggestions would be greatly appreciated.


Thanks,

John M
mozurkewichj (AT) mps (DOT) k12.mi.us

Reply With Quote
  #2  
Old   
John M
 
Posts: n/a

Default Re: Shared Memory Problems, Informix IDS 7.31 install on SCO UnixWare 7.1.1 - 06-25-2003 , 08:23 AM






Quote:
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


Reply With Quote
  #3  
Old   
John M
 
Posts: n/a

Default Re: Shared Memory Problems, Informix IDS 7.31 install on SCO UnixWare 7.1.1 - 06-25-2003 , 02:28 PM



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

Reply With Quote
  #4  
Old   
John M
 
Posts: n/a

Default Re: Shared Memory Problems, Informix IDS 7.31 install on SCO UnixWare 7.1.1 - 06-25-2003 , 02:32 PM



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

Reply With Quote
  #5  
Old   
Langelage, Frank
 
Posts: n/a

Default Re: Shared Memory Problems, Informix IDS 7.31 install on SCO UnixWare7.1.1 - 06-25-2003 , 05:37 PM



John M wrote:
Quote:
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.

Quote:
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.

?????



Reply With Quote
  #6  
Old   
John M
 
Posts: n/a

Default Re: Shared Memory Problems, Informix IDS 7.31 install on SCO UnixWare 7.1.1 - 06-30-2003 , 08:46 AM



Thanks for all of your help. I lowered the amount of initialy
reqquested shared memory and things seem to be working fine.


Thanks,
John M

Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.