Difference between 32bit Informix and 64bit Inform
A user running 13 Informix 7.31 (32-bit) instances on HP-UX 11.11 hit shared memory errors when starting a 14th instance and asked whether moving to a 64-bit build would help. Replies explained the main difference is addressable memory (roughly 1.5–4 GB per 32-bit instance, depending on OS/architecture, vs. up to ~4 TB for 64-bit), plus native 64-bit arithmetic. Consensus: 64-bit only helps if the server actually has free physical RAM; if the box is out of memory, more RAM is needed, and consolidating databases into fewer instances or checking OS SHMMAX/SHMMNI/SHMALL settings was suggested. The poster never described the exact error and no confirmed outcome is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
What are the difference between 32bit Informix and 64bit Informix version?
JAYANTA SARKAR wrote: > What are the difference between 32bit Informix and 64bit Informix version? One addresses 32-bit memory and one addresses 64-bit memory. -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com
32 Paul Watson Tel: +1 913-745-5635 Mob: +1 913-387-7529 Web: www.oninit.com Failure is not as frightening as regret. If you want to improve, be content to be thought foolish and stupid. It is better to be criticized by a wise person than to be praised by a fool. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of JAYANTA SARKAR Sent: Thursday, December 18, 2008 11:54 AM To: ids@iiug.org Subject: Difference between 32bit Informix and 64bit Inform [14361] What are the difference between 32bit Informix and 64bit Informix version? **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.
We have one HP Unix server 11.11 and running 13 instances of Informix version 7.31HD10(32 bit). When we try to start 14 instances, we are getting Shared memory problems. We can not reduce shared memory size of other instances for performance purpose. If we upgrade Informix 7.31FD6 (64 bit) version, is it help us?? Thanks Jayanta
JAYANTA SARKAR wrote: > When we try to start 14 instances, we are getting Shared > memory problems. Could you be a bit less specific, please? -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com
Yes, Jayanta, please pardon all my sarcastic collegues. That is precisely why you would want to upgrade to 64 bit, although going forward with 11.5 you will no longer be given a 32 bit option (or perhaps it will at least no longer be the default). As a DBA you want to have all your environments on 64 bit so that you can make use of much more memory for your buffers as well as allowing other enhancements. With 32 bit the maximum memory you can allocate for all your instances combined is 1.75 Gig and even that requires all the allocations to be at start to up to ensure you can grab this maximum value. This is Much, much greater with 64 bit though I do not know the exact number off the top of my head. I'm sure OTC or Paul would know that figure. Thanks! Kate Tomchik [ kate@iiug.org ] www.iiug.org International Informix Users Group Board of Directors I'm prepared for all emergencies but totally unprepared for everyday life. ---------- Original Message ----------- From: "JAYANTA SARKAR" <jayanta.js@gmail.com> To: ids@iiug.org Sent: Thu, 18 Dec 2008 13:06:33 -0500 (EST) Subject: Re: Difference between 32bit Informix and 64bit In [14364] > We have one HP Unix server 11.11 and running 13 instances of > Informix version > 7.31HD10(32 bit). When we try to start 14 instances, we are getting > Shared memory problems. We can not reduce shared memory size of > other instances for performance purpose. If we upgrade Informix > 7.31FD6 (64 bit) version, is it help us?? > > Thanks > Jayanta > > ***************************************************************************** ** Forum Note: Use "Reply" to post a response in the discussion forum. ------- End of Original Message -------
kate wrote: > Yes, Jayanta, please pardon all my sarcastic collegues. > > That is precisely why you would want to upgrade to 64 bit, although going > forward with 11.5 you will no longer be given a 32 bit option (or perhaps it > will at least no longer be the default). As a DBA you want to have all your > environments on 64 bit so that you can make use of much more memory for your > buffers as well as allowing other enhancements. > > With 32 bit the maximum memory you can allocate for all your instances > combined is 1.75 Gig and even that requires all the allocations to be at > start to up to ensure you can grab this maximum value. This is Much, much > greater with 64 bit though I do not know the exact number off the top of my > head. I'm sure OTC or Paul would know that figure. 4TB. -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com
See OTC is brilliant help when given a direct question! Course I enjoy the sarcastic ones more :-) Thanks! Kate Tomchik [ kate@iiug.org ] www.iiug.org International Informix Users Group Board of Directors I'm prepared for all emergencies but totally unprepared for everyday life. ---------- Original Message ----------- From: "Obnoxio The Clown" <obnoxio@serendipita.com> To: ids@iiug.org Sent: Thu, 18 Dec 2008 13:16:49 -0500 (EST) Subject: Re: Difference between 32bit Informix and 64bit In [14367] > kate wrote: > > Yes, Jayanta, please pardon all my sarcastic collegues. > > > > That is precisely why you would want to upgrade to 64 bit, although going > > forward with 11.5 you will no longer be given a 32 bit option (or perhaps it > > will at least no longer be the default). As a DBA you want to have all your > > environments on 64 bit so that you can make use of much more memory for your > > buffers as well as allowing other enhancements. > > > > With 32 bit the maximum memory you can allocate for all your instances > > combined is 1.75 Gig and even that requires all the allocations to be at > > start to up to ensure you can grab this maximum value. This is Much, much > > greater with 64 bit though I do not know the exact number off the top of my > > head. I'm sure OTC or Paul would know that figure. > > 4TB. > > -- > Cheers, > Obnoxio The Clown > > http://obotheclown.blogspot.com > > ***************************************************************************** ** Forum Note: Use "Reply" to post a response in the discussion forum. ------- End of Original Message -------
kate wrote: > See OTC is brilliant help when given a direct question! > > Course I enjoy the sarcastic ones more :-) Well, it was pretty hard to guess what the problem was, given that I'm not psychotic like you. :o) -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com
Jealously is so unbecoming! Thanks! Kate Tomchik [ kate@iiug.org ] www.iiug.org International Informix Users Group Board of Directors I'm prepared for all emergencies but totally unprepared for everyday life. ---------- Original Message ----------- From: "Obnoxio The Clown" <obnoxio@serendipita.com> To: ids@iiug.org Sent: Thu, 18 Dec 2008 13:21:43 -0500 (EST) Subject: Re: Difference between 32bit Informix and 64bit In [14369] > kate wrote: > > See OTC is brilliant help when given a direct question! > > > > Course I enjoy the sarcastic ones more :-) > > Well, it was pretty hard to guess what the problem was, given that > I'm not psychotic like you. :o) > > -- > Cheers, > Obnoxio The Clown > > http://obotheclown.blogspot.com > > ***************************************************************************** ** Forum Note: Use "Reply" to post a response in the discussion forum. ------- End of Original Message -------
Sounds like you are running out of available physical memory for SHM for the 14th instance. Perhaps you need to add more memory to the server? -- Bob -------------- Original message -------------- From: "JAYANTA SARKAR" <jayanta.js@gmail.com> > We have one HP Unix server 11.11 and running 13 instances of Informix version > 7.31HD10(32 bit). When we try to start 14 instances, we are getting Shared > memory problems. We can not reduce shared memory size of other instances for > performance purpose. If we upgrade Informix 7.31FD6 (64 bit) version, is it > help us?? > > Thanks > Jayanta > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
I agree with Bob, you are running our of memory on the server. The 64bit version won't help if you don't add more memory to the server. Is there a specific reason you need to run 14 instances instead of 1 instance with multiple databases? Lennie On Thu, Dec 18, 2008 at 12:38 PM, rroussey@comcast.net <rroussey@comcast.net > wrote: > Sounds like you are running out of available physical memory for SHM for > the > 14th instance. > Perhaps you need to add more memory to the server? > > -- > Bob > > -------------- Original message -------------- > From: "JAYANTA SARKAR" <jayanta.js@gmail.com> > > > We have one HP Unix server 11.11 and running 13 instances of Informix > version > > 7.31HD10(32 bit). When we try to start 14 instances, we are getting > Shared > > memory problems. We can not reduce shared memory size of other instances > for > > performance purpose. If we upgrade Informix 7.31FD6 (64 bit) version, is > it > > help us?? > > > > Thanks > > Jayanta > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >
This is simple to check. If you see plenty of memory on the box just verify
the footprint of all the informix instances by doing an onstat - of each
instance, and summing up the Kbytes used. If the total of all the
environments is close to 1,800,000 Kbytes you need 64 bit.
Example output:
>onstat -
IBM Informix Dynamic Server Version 11.10.FC2W2 -- On-Line -- Up 62 days
12:10:15 -- 927096 Kbytes
Thanks!
Kate Tomchik [ kate@iiug.org ] www.iiug.org
International Informix Users Group Board of Directors
I'm prepared for all emergencies but totally unprepared for everyday
life.
---------- Original Message -----------
From: "Lennie Jarratt" <lennie@jarratt.ws>
To: ids@iiug.org
Sent: Thu, 18 Dec 2008 14:01:16 -0500 (EST)
Subject: Re: Difference between 32bit Informix and 64bit In [14372]
> I agree with Bob, you are running our of memory on the server. The
> 64bit version won't help if you don't add more memory to the server.
>
> Is there a specific reason you need to run 14 instances instead of 1
> instance with multiple databases?
>
> Lennie
>
> On Thu, Dec 18, 2008 at 12:38 PM, rroussey@comcast.net
> <rroussey@comcast.net
> > wrote:
>
> > Sounds like you are running out of available physical memory for SHM for
> > the
> > 14th instance.
> > Perhaps you need to add more memory to the server?
> >
> > --
> > Bob
> >
> > -------------- Original message --------------
> > From: "JAYANTA SARKAR" <jayanta.js@gmail.com>
> >
> > > We have one HP Unix server 11.11 and running 13 instances of Informix
> > version
> > > 7.31HD10(32 bit). When we try to start 14 instances, we are getting
> > Shared
> > > memory problems. We can not reduce shared memory size of other
instances
> > for
> > > performance purpose. If we upgrade Informix 7.31FD6 (64 bit) version,
is
> > it
> > > help us??
> > >
> > > Thanks
> > > Jayanta
> > >
> > >
> > >
> >
> >
>
*****************************************************************************
**
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> >
> >
> >
> >
>
*****************************************************************************
**
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
>
*****************************************************************************
** Forum Note: Use "Reply" to post a response in the discussion forum.
------- End of Original Message -------
Actually the limit on IDS 32bits is around 3.75GB "per instance". If you have
enough physical memory and still shared memory problems I'd look to SHMxxx
parameters at OS level. Most likely you are hitting some OS limitation.
There is a lot of guessing on all of these answers because you did not explain
what kind of "shared memory problems" you are experiencing.
Walter Milan
DBA
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of kate
Sent: Thursday, December 18, 2008 1:32 PM
To: ids@iiug.org
Subject: Re: Difference between 32bit Informix and 64bit In [14373]
This is simple to check. If you see plenty of memory on the box just verify
the footprint of all the informix instances by doing an onstat - of each
instance, and summing up the Kbytes used. If the total of all the
environments is close to 1,800,000 Kbytes you need 64 bit.
Example output:
>onstat -
IBM Informix Dynamic Server Version 11.10.FC2W2 -- On-Line -- Up 62 days
12:10:15 -- 927096 Kbytes
Thanks!
Kate Tomchik [ kate@iiug.org ] www.iiug.org
International Informix Users Group Board of Directors
I'm prepared for all emergencies but totally unprepared for everyday
life.
---------- Original Message -----------
From: "Lennie Jarratt" <lennie@jarratt.ws>
To: ids@iiug.org
Sent: Thu, 18 Dec 2008 14:01:16 -0500 (EST)
Subject: Re: Difference between 32bit Informix and 64bit In [14372]
> I agree with Bob, you are running our of memory on the server. The
> 64bit version won't help if you don't add more memory to the server.
>
> Is there a specific reason you need to run 14 instances instead of 1
> instance with multiple databases?
>
> Lennie
>
> On Thu, Dec 18, 2008 at 12:38 PM, rroussey@comcast.net
> <rroussey@comcast.net
> > wrote:
>
> > Sounds like you are running out of available physical memory for SHM for
> > the
> > 14th instance.
> > Perhaps you need to add more memory to the server?
> >
> > --
> > Bob
> >
> > -------------- Original message --------------
> > From: "JAYANTA SARKAR" <jayanta.js@gmail.com>
> >
> > > We have one HP Unix server 11.11 and running 13 instances of Informix
> > version
> > > 7.31HD10(32 bit). When we try to start 14 instances, we are getting
> > Shared
> > > memory problems. We can not reduce shared memory size of other
instances
> > for
> > > performance purpose. If we upgrade Informix 7.31FD6 (64 bit) version,
is
> > it
> > > help us??
> > >
> > > Thanks
> > > Jayanta
> > >
> > >
> > >
> >
> >
>
*****************************************************************************
**
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> >
> >
> >
> >
>
*****************************************************************************
**
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
>
*****************************************************************************
** Forum Note: Use "Reply" to post a response in the discussion forum.
------- End of Original Message -------
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
It that is true it is new for version 11. It is not true for previous
versions.
Thanks!
Kate Tomchik [ kate@iiug.org ] www.iiug.org
International Informix Users Group Board of Directors
I'm prepared for all emergencies but totally unprepared for everyday
life.
---------- Original Message -----------
From: "Walter Milan" <Walter.Milan@hilton.com>
To: ids@iiug.org
Sent: Thu, 18 Dec 2008 16:30:52 -0500 (EST)
Subject: RE: Difference between 32bit Informix and 64bit In [14375]
> Actually the limit on IDS 32bits is around 3.75GB "per instance". If
> you have enough physical memory and still shared memory problems I'd
> look to SHMxxx parameters at OS level. Most likely you are hitting
> some OS limitation. There is a lot of guessing on all of these
> answers because you did not explain what kind of "shared memory
> problems" you are experiencing.
>
> Walter Milan
> DBA
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf
> Of kate Sent: Thursday, December 18, 2008 1:32 PM To: ids@iiug.org
> Subject: Re: Difference between 32bit Informix and 64bit In [14373]
>
> This is simple to check. If you see plenty of memory on the box just
> verify the footprint of all the informix instances by doing an
> onstat - of each instance, and summing up the Kbytes used. If the
> total of all the environments is close to 1,800,000 Kbytes you need
> 64 bit.
>
> Example output:
> >onstat -
> IBM Informix Dynamic Server Version 11.10.FC2W2 -- On-Line -- Up 62> days
> 12:10:15 -- 927096 Kbytes
>
> Thanks!
> Kate Tomchik [ kate@iiug.org ] www.iiug.org
> International Informix Users Group Board of Directors
>
> I'm prepared for all emergencies but totally unprepared for everyday
> life.
>
> ---------- Original Message -----------
> From: "Lennie Jarratt" <lennie@jarratt.ws>
> To: ids@iiug.org
> Sent: Thu, 18 Dec 2008 14:01:16 -0500 (EST)
> Subject: Re: Difference between 32bit Informix and 64bit In [14372]
>
> > I agree with Bob, you are running our of memory on the server. The
> > 64bit version won't help if you don't add more memory to the server.
> >
> > Is there a specific reason you need to run 14 instances instead of 1
> > instance with multiple databases?
> >
> > Lennie
> >
> > On Thu, Dec 18, 2008 at 12:38 PM, rroussey@comcast.net
> > <rroussey@comcast.net
> > > wrote:
> >
> > > Sounds like you are running out of available physical memory for SHM
for
> > > the
> > > 14th instance.
> > > Perhaps you need to add more memory to the server?
> > >
> > > --
> > > Bob
> > >
> > > -------------- Original message --------------
> > > From: "JAYANTA SARKAR" <jayanta.js@gmail.com>
> > >
> > > > We have one HP Unix server 11.11 and running 13 instances of
Informix
> > > version
> > > > 7.31HD10(32 bit). When we try to start 14 instances, we are getting
> > > Shared
> > > > memory problems. We can not reduce shared memory size of other
> instances
> > > for
> > > > performance purpose. If we upgrade Informix 7.31FD6 (64 bit)
version,
> is
> > > it
> > > > help us??
> > > >
> > > > Thanks
> > > > Jayanta
> > > >
> > > >
> > > >
> > >
> > >
> >
>
*****************************************************************************
**
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > >
> > >
> > >
> > >
> >
>
*****************************************************************************
**
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> >
>
*****************************************************************************
** Forum Note: Use "Reply" to post a response in the discussion forum.
> ------- End of Original Message -------
>
>
*****************************************************************************
** Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
*****************************************************************************
** Forum Note: Use "Reply" to post a response in the discussion forum.
------- End of Original Message -------
Basically the difference between a 32-bit build and a 64-bit build is addressability space. 32-bit pointers will have a 4 GIG limit in the s= ize of memory that can be addressed. 64-bit builds have an addressability limit of 4 TBytes. Also with a 32-bit build 64-bit math is done by using simulation. Wit= h a 64-bit build it is done by machine operations. (Even a long long is re= ally a simulation using two 32-bit integers. It's just that the simulation = is performed by the compiler. ------------------------------------- Madison Pruet, STSM IDS Replication Architect = "JAYANTA SARKAR" = <jayanta.js@gmail = .com> = To Sent by: ids@iiug.org = ids-bounces@iiug. = cc org = Subj= ect Difference between 32bit Informi= x 12/18/2008 11:54 and 64bit Inform [14361] = AM = = = Please respond to = ids@iiug.org = = = What are the difference between 32bit Informix and 64bit Informix versi= on? ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =
Don't know what OS you are using but on Solaris, LINUX, and AIX we have been
able to configure near 3.75 GB., at least since 9.4 when I started having this
issue, just tweaking the SHMMAX, SHMMNI, SHMALL ... kernel parameters.
Walter Milan
DBA
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of kate
Sent: Thursday, December 18, 2008 3:36 PM
To: ids@iiug.org
Subject: RE: Difference between 32bit Informix and 64bit In [14376]
It that is true it is new for version 11. It is not true for previous
versions.
Thanks!
Kate Tomchik [ kate@iiug.org ] www.iiug.org
International Informix Users Group Board of Directors
I'm prepared for all emergencies but totally unprepared for everyday
life.
---------- Original Message -----------
From: "Walter Milan" <Walter.Milan@hilton.com>
To: ids@iiug.org
Sent: Thu, 18 Dec 2008 16:30:52 -0500 (EST)
Subject: RE: Difference between 32bit Informix and 64bit In [14375]
> Actually the limit on IDS 32bits is around 3.75GB "per instance". If
> you have enough physical memory and still shared memory problems I'd
> look to SHMxxx parameters at OS level. Most likely you are hitting
> some OS limitation. There is a lot of guessing on all of these
> answers because you did not explain what kind of "shared memory
> problems" you are experiencing.
>
> Walter Milan
> DBA
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf
> Of kate Sent: Thursday, December 18, 2008 1:32 PM To: ids@iiug.org
> Subject: Re: Difference between 32bit Informix and 64bit In [14373]
>
> This is simple to check. If you see plenty of memory on the box just
> verify the footprint of all the informix instances by doing an
> onstat - of each instance, and summing up the Kbytes used. If the
> total of all the environments is close to 1,800,000 Kbytes you need
> 64 bit.
>
> Example output:
> >onstat -
> IBM Informix Dynamic Server Version 11.10.FC2W2 -- On-Line -- Up 62> days
> 12:10:15 -- 927096 Kbytes
>
> Thanks!
> Kate Tomchik [ kate@iiug.org ] www.iiug.org
> International Informix Users Group Board of Directors
>
> I'm prepared for all emergencies but totally unprepared for everyday
> life.
>
> ---------- Original Message -----------
> From: "Lennie Jarratt" <lennie@jarratt.ws>
> To: ids@iiug.org
> Sent: Thu, 18 Dec 2008 14:01:16 -0500 (EST)
> Subject: Re: Difference between 32bit Informix and 64bit In [14372]
>
> > I agree with Bob, you are running our of memory on the server. The
> > 64bit version won't help if you don't add more memory to the server.
> >
> > Is there a specific reason you need to run 14 instances instead of 1
> > instance with multiple databases?
> >
> > Lennie
> >
> > On Thu, Dec 18, 2008 at 12:38 PM, rroussey@comcast.net
> > <rroussey@comcast.net
> > > wrote:
> >
> > > Sounds like you are running out of available physical memory for SHM
for
> > > the
> > > 14th instance.
> > > Perhaps you need to add more memory to the server?
> > >
> > > --
> > > Bob
> > >
> > > -------------- Original message --------------
> > > From: "JAYANTA SARKAR" <jayanta.js@gmail.com>
> > >
> > > > We have one HP Unix server 11.11 and running 13 instances of
Informix
> > > version
> > > > 7.31HD10(32 bit). When we try to start 14 instances, we are getting
> > > Shared
> > > > memory problems. We can not reduce shared memory size of other
> instances
> > > for
> > > > performance purpose. If we upgrade Informix 7.31FD6 (64 bit)
version,
> is
> > > it
> > > > help us??
> > > >
> > > > Thanks
> > > > Jayanta
> > > >
> > > >
> > > >
> > >
> > >
> >
>
*****************************************************************************
**
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > >
> > >
> > >
> > >
> >
>
*****************************************************************************
**
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> >
>
*****************************************************************************
** Forum Note: Use "Reply" to post a response in the discussion forum.
> ------- End of Original Message -------
>
>
*****************************************************************************
** Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
*****************************************************************************
** Forum Note: Use "Reply" to post a response in the discussion forum.
------- End of Original Message -------
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Mainly that 64bit IDS can use more memory, uses 64bit values and instructions internally which is sometimes faster and more efficient, and because of the added memory available a small number of ONCONFIG parameters have expanded value ranges in the 64bit releases. Art On Thu, Dec 18, 2008 at 12:54 PM, JAYANTA SARKAR <jayanta.js@gmail.com>wrote: > What are the difference between 32bit Informix and 64bit Informix version? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.
Almost Kate. Each 32bit instance can access up to from 1.5 to 4GB of memory (more or less depending on the specific OS and CPU architecture and sizes of the shared libraries it must load at runtime. Each 64bit instance can access up to about 4TB of memory (again depending on the architecture). However, as pointed out, if the users is running out of memory altogether a bigger address space will not help. Now, having said that, combining all 14 servers' databases into a single instance (or smaller number of instances) will free up much redundant memory and that MAY also require that they upgrade to a 64bit IDS release. However, again, if there is a physical memory restraint, also as already pointed out, they will have to add more memory to take best advantage of the engine. Art On Thu, Dec 18, 2008 at 1:14 PM, kate <kate@iiug.org> wrote: > Yes, Jayanta, please pardon all my sarcastic collegues. > > That is precisely why you would want to upgrade to 64 bit, although going > forward with 11.5 you will no longer be given a 32 bit option (or perhaps > it > will at least no longer be the default). As a DBA you want to have all your > environments on 64 bit so that you can make use of much more memory for > your > buffers as well as allowing other enhancements. > > With 32 bit the maximum memory you can allocate for all your instances > combined is 1.75 Gig and even that requires all the allocations to be at > start to up to ensure you can grab this maximum value. This is Much, much > greater with 64 bit though I do not know the exact number off the top of my > head. I'm sure OTC or Paul would know that figure. > > Thanks! > Kate Tomchik [ kate@iiug.org ] www.iiug.org > International Informix Users Group Board of Directors > > I'm prepared for all emergencies but totally unprepared for everyday > life. > > ---------- Original Message ----------- > From: "JAYANTA SARKAR" <jayanta.js@gmail.com> > To: ids@iiug.org > Sent: Thu, 18 Dec 2008 13:06:33 -0500 (EST) > Subject: Re: Difference between 32bit Informix and 64bit In [14364] > > > We have one HP Unix server 11.11 and running 13 instances of > > Informix version > > 7.31HD10(32 bit). When we try to start 14 instances, we are getting > > Shared memory problems. We can not reduce shared memory size of > > other instances for performance purpose. If we upgrade Informix > > 7.31FD6 (64 bit) version, is it help us?? > > > > Thanks > > Jayanta > > > > > > ***************************************************************************** > ** Forum Note: Use "Reply" to post a response in the discussion forum. > ------- End of Original Message ------- > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.
AFAIK it's always been that way.
Art
On Thu, Dec 18, 2008 at 4:35 PM, kate <kate@iiug.org> wrote:
> It that is true it is new for version 11. It is not true for previous
> versions.
>
> Thanks!
> Kate Tomchik [ kate@iiug.org ] www.iiug.org
> International Informix Users Group Board of Directors
>
> I'm prepared for all emergencies but totally unprepared for everyday
> life.
>
> ---------- Original Message -----------
> From: "Walter Milan" <Walter.Milan@hilton.com>
> To: ids@iiug.org
> Sent: Thu, 18 Dec 2008 16:30:52 -0500 (EST)
> Subject: RE: Difference between 32bit Informix and 64bit In [14375]
>
> > Actually the limit on IDS 32bits is around 3.75GB "per instance". If
> > you have enough physical memory and still shared memory problems I'd
> > look to SHMxxx parameters at OS level. Most likely you are hitting
> > some OS limitation. There is a lot of guessing on all of these
> > answers because you did not explain what kind of "shared memory
> > problems" you are experiencing.
> >
> > Walter Milan
> > DBA
> >
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf
> > Of kate Sent: Thursday, December 18, 2008 1:32 PM To: ids@iiug.org
> > Subject: Re: Difference between 32bit Informix and 64bit In [14373]
> >
> > This is simple to check. If you see plenty of memory on the box just
> > verify the footprint of all the informix instances by doing an
> > onstat - of each instance, and summing up the Kbytes used. If the
> > total of all the environments is close to 1,800,000 Kbytes you need
> > 64 bit.
> >
> > Example output:
> > >onstat -
> > IBM Informix Dynamic Server Version 11.10.FC2W2 -- On-Line -- Up 62> > days
> > 12:10:15 -- 927096 Kbytes
> >
> > Thanks!
> > Kate Tomchik [ kate@iiug.org ] www.iiug.org
> > International Informix Users Group Board of Directors
> >
> > I'm prepared for all emergencies but totally unprepared for everyday
> > life.
> >
> > ---------- Original Message -----------
> > From: "Lennie Jarratt" <lennie@jarratt.ws>
> > To: ids@iiug.org
> > Sent: Thu, 18 Dec 2008 14:01:16 -0500 (EST)
> > Subject: Re: Difference between 32bit Informix and 64bit In [14372]
> >
> > > I agree with Bob, you are running our of memory on the server. The
> > > 64bit version won't help if you don't add more memory to the server.
> > >
> > > Is there a specific reason you need to run 14 instances instead of 1
> > > instance with multiple databases?
> > >
> > > Lennie
> > >
> > > On Thu, Dec 18, 2008 at 12:38 PM, rroussey@comcast.net
> > > <rroussey@comcast.net
> > > > wrote:
> > >
> > > > Sounds like you are running out of available physical memory for SHM
> for
> > > > the
> > > > 14th instance.
> > > > Perhaps you need to add more memory to the server?
> > > >
> > > > --
> > > > Bob
> > > >
> > > > -------------- Original message --------------
> > > > From: "JAYANTA SARKAR" <jayanta.js@gmail.com>
> > > >
> > > > > We have one HP Unix server 11.11 and running 13 instances of
> Informix
> > > > version
> > > > > 7.31HD10(32 bit). When we try to start 14 instances, we are getting
> > > > Shared
> > > > > memory problems. We can not reduce shared memory size of other
> > instances
> > > > for
> > > > > performance purpose. If we upgrade Informix 7.31FD6 (64 bit)
> version,
> > is
> > > > it
> > > > > help us??
> > > > >
> > > > > Thanks
> > > > > Jayanta
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> >
>
> *****************************************************************************
> **
> > > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > > >
> > > >
> > > >
> > > >
> > > >
> > >
> >
>
> *****************************************************************************
> **
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > > >
> > >
> > >
> >
>
> *****************************************************************************
> ** Forum Note: Use "Reply" to post a response in the discussion forum.
> > ------- End of Original Message -------
> >
> >
>
> *****************************************************************************
> ** Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> *****************************************************************************
> ** Forum Note: Use "Reply" to post a response in the discussion forum.
> ------- End of Original Message -------
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
JAYANTA SARKAR wrote: > We have one HP Unix server 11.11 and running 13 instances of Informix version > 7.31HD10(32 bit). When we try to start 14 instances, we are getting Shared > memory problems. We can not reduce shared memory size of other instances for > performance purpose. If we upgrade Informix 7.31FD6 (64 bit) version, is it > help us?? > It depends. But probably it will not help. Why ? Because - and I admit I only infered this form your detailed problem and error description - that the 14th instance fails as there is no more physical and or virtual memory available on the UNIX server. If this is the case I suggest you buy more physical memory for the server. Also you might want to check swapping or paging activity of the sevrer. If there is a lot, your performance might benefit from more physical RAM. However, as I said - this is mere speculation based on your above problem description. HTH Tilman
Walter Milan wrote: > Actually the limit on IDS 32bits is around 3.75GB "per instance". If you have > enough physical memory and still shared memory problems I'd look to SHMxxx > parameters at OS level. Most likely you are hitting some OS limitation. > There is a lot of guessing on all of these answers because you did not explain > what kind of "shared memory problems" you are experiencing. > > Walter Milan > DBA > 3.75 GB is on SOLARIS As far as I remember. Its probably less on other UNIX flavours, depending on how memroy is reserved for kernel and shared libs. On AIX 2.75GB is maximum (with usage of EXTSHM environment variable) for any 32 bit process. (11 segments a 256 MB ) Don't recall the details for 32 bit processes on HP-UX but I think it was less than 3.75 GB. Rgds Tilman