Maximum shared memory for Informix 7.3 on SCO 3.2v5.0.5
Posted in 2006
Topics: Versions, Editions & End-of-Life
Hi !!!
Yesterday I configured an instance of IDS 9.3 on RedHat and changed the
shared libraries base address, so now I'm using over 2GB of shared
memory for Informix with one million buffers
echo 0xB0000000L > /proc/$$/mapped_base
su -l informix -c oninit -v
I also have an old SCO 3.2v5.0.5 with IDS 7.3, and I would really like
to use more memory for that instance, because I've been unable to use
more than 300000 buffers. Is there a way to change the shared libraries
base address on SCO 3.2? Maybe another trick to use more memory?
Thanks in advance for your help !!!
Manuel Daponte
MADS wrote:
> Hi !!!
>
> Yesterday I configured an instance of IDS 9.3 on RedHat and changed the
> shared libraries base address, so now I'm using over 2GB of shared
> memory for Informix with one million buffers
>
> echo 0xB0000000L > /proc/$$/mapped_base
> su -l informix -c oninit -v
IDS 9.3 on Linux is 32 bit (there isn't a 64 bit version) and so the
most RAM you can possibly address is 4Gb or you run out of bits. If
you've got over 2Gb shared memory and 1,000,000 buffers on a 2k page
size you're over 4Gb which isn't possible without swapping. Your OS and
other programs need to fit in somewhere as well. Am I reading your post
correctly?
> I also have an old SCO 3.2v5.0.5 with IDS 7.3, and I would really like
> to use more memory for that instance, because I've been unable to use
> more than 300000 buffers. Is there a way to change the shared libraries
> base address on SCO 3.2? Maybe another trick to use more memory?
In SCO 5.0.5 you can change the kernel parameters by running scoadmin,
selecting Hardware/Kernel Manager and then Tune Parameters. You then
have to relink the kernel and reboot. However I don't recommend this or
guarantee that a similar trick would work as on Linux where the change
of mapped_base is in the machine notes from Informix. Is there anything
in the machine notes for SCO? I would only follow what's in there.
Ben.
Well, actually the one million buffers are part of the 2.2 GB of RAM
(onstat -g seg shows me that)
Anyway, the IDS version for SCO is 7.31.UC5, and the release notes
don't show anything about that
=================================
MACHINE SPECIFIC NOTES
FOR
Informix Dynamic Server 7.31.UC5 PRODUCT RELEASE
DATE: 23 Nov 1999
=================================
INFORMIX-OnLine Shared Memory Parameters (in Bytes):
===================================================
SHMMAX: 409600000
SHMMIN: 1
SHMALL: 512
SHMMNI: 100
SHMSEG: 6
LOCATION OF SHARED MEMORY:
=========================
SHMBASE 0x82000000L
Kernel Parameters recommended for Informix ONLINE:
==================================================
MAXUMEM:524287
SEMMNI: 8192
SEMMNS: 8192
SEMMAP: 8192
SEMMNU: 100
SEMMSL: 25
Kernel Parameters that might have to be changed
depending on the Online configuration:
======================================
MAXUP
SEMMNI
SEMMNS
SEMMSL
NFILE
Ben Thompson wrote:
> MADS wrote:
> > Hi !!!
> >
> > Yesterday I configured an instance of IDS 9.3 on RedHat and changed the
> > shared libraries base address, so now I'm using over 2GB of shared
> > memory for Informix with one million buffers
> >
> > echo 0xB0000000L > /proc/$$/mapped_base
> > su -l informix -c oninit -v
>
> IDS 9.3 on Linux is 32 bit (there isn't a 64 bit version) and so the
> most RAM you can possibly address is 4Gb or you run out of bits. If
> you've got over 2Gb shared memory and 1,000,000 buffers on a 2k page
> size you're over 4Gb which isn't possible without swapping. Your OS and
> other programs need to fit in somewhere as well. Am I reading your post
> correctly?
>
> > I also have an old SCO 3.2v5.0.5 with IDS 7.3, and I would really like
> > to use more memory for that instance, because I've been unable to use
> > more than 300000 buffers. Is there a way to change the shared libraries
> > base address on SCO 3.2? Maybe another trick to use more memory?
>
> In SCO 5.0.5 you can change the kernel parameters by running scoadmin,
> selecting Hardware/Kernel Manager and then Tune Parameters. You then
> have to relink the kernel and reboot. However I don't recommend this or
> guarantee that a similar trick would work as on Linux where the change
> of mapped_base is in the machine notes from Informix. Is there anything
> in the machine notes for SCO? I would only follow what's in there.
>
> Ben.
MADS wrote:
> Well, actually the one million buffers are part of the 2.2 GB of RAM
> (onstat -g seg shows me that)
OK, that explains it - double counting. Thanks.
> Anyway, the IDS version for SCO is 7.31.UC5, and the release notes
> don't show anything about that
>
> =================================
> MACHINE SPECIFIC NOTES
> FOR
> Informix Dynamic Server 7.31.UC5 PRODUCT RELEASE
> DATE: 23 Nov 1999
> =================================
>
> INFORMIX-OnLine Shared Memory Parameters (in Bytes):
> ===================================================
>
> SHMMAX: 409600000
> SHMMIN: 1
> SHMALL: 512
> SHMMNI: 100
> SHMSEG: 6
>
> LOCATION OF SHARED MEMORY:
> =========================
> SHMBASE 0x82000000L>
> Kernel Parameters recommended for Informix ONLINE:
> ==================================================
>
> MAXUMEM:524287
> SEMMNI: 8192
> SEMMNS: 8192
> SEMMAP: 8192
> SEMMNU: 100
> SEMMSL: 25
>
> Kernel Parameters that might have to be changed
> depending on the Online configuration:
> ======================================
>
> MAXUP
> SEMMNI
> SEMMNS
> SEMMSL
> NFILE
I think all I can recommend is setting the kernel parameters as per the
release notes if you haven't done so already. I don't think any of the
adjustable ones are going to change your base memory address and allow
more memory to be used and you can't dynamically change the parameters
as with Linux. I suppose you have tried incrementing the BUFFERS
parameter until the engine fails to start? I think the way forward is to
migrate to Linux. Sorry if this is of limited help.
Ben.
Related threads
- Posting from the Informix-list
- Migrating from IDS 9.40.UC6 to 11.50.UC3
- Ip for a network session
- questions onstat -g