RE: semaphore tuning
This is a multi-part message in MIME format.
------_=_NextPart_001_01C4FF55.C0AA05EA
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Hi Floyd,
=20
>>Informix9.4-UC4 on Solaris 9 =20
=20
UC4?... that's a 32Bit version.
you did not post the entire error from your online log, what happens
before your series of errno=3D22?
=20
while you have the system shmmax set to:
set shmsys:shminfo_shmmax=3D4294967296
an IDS 32 bit version will top out at 3.75GB of memory or something
close to that (at least it did on IDS 7.31 versions).
I am guessing your engine wants more memory, but is not designed to go
higher.... so upgrade to a 64bit version (IDS 9.4 with a F where the
U is in the full version number).
=20
i=2Ee...check your "onstat -" and see what your total memory is. Ours
is:
IBM Informix Dynamic Server Version 9.40.FC3XD -- On-Line -- Up
02:24:34 -- 5570560 Kbytes =20The 5.57 GB number at the end means my engine takes 5.57GB of memory.
the 9.40.F.... means I am a 64 bit version.
=20
the number on the 'onstat -' line is not exact, if you do a 'onstat -g
seg' you get more specific:
=20
onstat -g seg
IBM Informix Dynamic Server Version 9.40.FC3XD -- On-Line -- Up
02:25:56 -- 5570560 KbytesSegment Summary:
id key addr size
ovhd class blkused blkfree=20
4097 1383352321 10a000000 1929379840 477568 R*
467823 3217 =20
4098 1383352322 17d000000 3758096384 115344 V
63473 854031 =20
4099 1383352323 25d000000 2097152 720 M
317 195 =20
4100 1383352324 25d200000 2097152 720 M
309 203 =20
4101 1383352325 25d400000 2097152 720 M
309 203 =20
4102 1383352326 25d600000 2097152 720 M
309 203 =20
4103 1383352327 25d800000 2097152 720 M
309 203 =20
4104 1383352328 25da00000 2097152 720 M
309 203 =20
4105 1383352329 25dc00000 2097152 720 M
309 203 =20
4106 1383352330 25de00000 2097152 720 M
309 203 =20
Total: - - 5704253440 -
- 533776 858864 =20
(* segment locked in memory)
=20
The size column here sums to 5.7GB whereas the "onstat -" showed 5.57GB.
The classes in the above output are R=3Dresident, V=3DVirtual, M=3Dmessage.
=20
Hope this info helps you with your situation,
Norma Jean
=20
=20
=20
________________________________
From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]
On Behalf Of Floyd Wellershaus
Sent: Thursday, January 20, 2005 4:59 PM
To: informix-list@iiug.org
Subject: semaphore tuning
We are running Informix9.4-UC4 on Solaris 9.
We are getting intermittent semctl: errno =3D 22 errors that are causing
assert failures.
=20
Our current kernel settings for semaphores are:
set semsys:seminfo_semmap=3D64
set semsys:seminfo_semmni=3D4096
set semsys:seminfo_semmns=3D4096
set semsys:seminfo_semmnu=3D4096
set semsys:seminfo_semume=3D64
set semsys:seminfo_semmsl=3D500
set shmsys:shminfo_shmmax=3D4294967296
set shmsys:shminfo_shmmin=3D100
set shmsys:shminfo_shmmni=3D500
set shmsys:shminfo_shmseg=3D100
Is there any recommendation to determine what to up the semaphore values
to ? Which value is it, is it the semmns value ?
=20
Thanks,
Floyd
=20
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
-<<Floyd Wellershaus>>-
Database Administrator
Unix Administrator
email: fwellers@yahoo.com
Work: 703-733-4126
Pager: 703-705-9241=20
Email Pager: 7037059241@my2way.com
Home: 703-430-0805
Cell: 703-477-6045
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
The information contained in this message may be privileged
and confidential and protected from disclosure. If the reader
of this message is not the intended recipient, or an employee
or agent responsible for delivering this message to the
intended recipient, you are hereby notified that any reproduction,
dissemination or distribution of this communication is strictly
prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and
deleting it from your computer. Thank you. Tellabs
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
------_=_NextPart_001_01C4FF55.C0AA05EA
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2743.600" name=3DGENERATOR></HEAD>
<BODY>
<DIV dir=3Dltr align=3Dleft><FONT face=3DArial color=3D#0000ff size=3D2><SP=
AN=20
class=3D836445600-21012005>Hi Floyd,</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2></FONT> </DIV>
<DIV><SPAN class=3D836445600-21012005>>></SPAN>Informix9.4-UC4 on Sol=
aris=20
9<SPAN class=3D836445600-21012005> </SPAN></D=
IV>
<DIV><SPAN class=3D836445600-21012005><FONT face=3DArial color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D836445600-21012005><FONT face=3DArial color=3D#0000ff=20
size=3D2>UC4?... that's a 32Bit version.</FONT></SPAN></D=
IV>
<DIV><SPAN class=3D836445600-21012005><FONT face=3DArial color=3D#0000ff si=
ze=3D2>you=20
did not post the entire error from your online log, what happens before you=
r=20
series of errno=3D22?</FONT></SPAN></DIV>
<DIV><SPAN class=3D836445600-21012005><FONT face=3DArial color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D836445600-21012005><FONT face=3DArial color=3D#0000ff si=
ze=3D2>while=20
you have the system shmmax set to:</FONT></SPAN></DIV>
<DIV><SPAN class=3D836445600-21012005>set=20
shmsys:shminfo_shmmax=3D4294967296<BR></SPAN></DIV>
<DIV><SPAN class=3D836445600-21012005><FONT face=3DArial color=3D#0000ff si=
ze=3D2>an IDS=20
32 bit version will top out at 3.75GB of memory or something close to that =
(at=20
least it did on IDS 7.31 versions).</FONT></SPAN></DIV>
<DIV><SPAN class=3D836445600-21012005><FONT face=3DArial color=3D#0000ff si=
ze=3D2>I am=20
guessing your engine wants more memory, but is not designed to go=20
higher.... so upgrade to a 64bit version (IDS 9.4 with a F =
;=20
where the U is in the full version number).</FONT></SPA