Informix Memory error on Windows
Problem: IDS 9.4 on Windows 2000/2003 — once shared memory grows to roughly 1.8GB, onstat/on* utilities fail with errors like "shared memory not initialized" or "cannot connect", although the running instance keeps serving already-connected sessions; it was reproducible by raising buffers or SHMBASE. Advice given: 32-bit Windows caps you near 1.8GB unless /3GB is used (~2.7GB), and the real culprit is usually a DLL loaded at an address that fragments the client process's address space — use Process Explorer on an onstat.exe process to list DLL load addresses and send that, plus onstat -g seg and boot.ini, to the open PMR. Keeping SHMBASE at the default 0xC000000 was recommended (higher values reduce usable shared memory), though the poster reported 0x50000000 seemed to help in a test environment. No confirmed resolution is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
We are having an issue with IDS 9.4 on Windows 2000 and 2003 - if the memory reaches around 1.8G the "on" commands stop working - we see everything from "shared memory not initialized" to "cannot connect" with no other information and the instance is running and if you are on the system before it reaches this level you can still work. We have duplicated this by setting either the SHMBASE or buffers up till we get in the range of 1.8G Memory and it all stops. IBM thinks it's a windows bug but I have nothing to take to MS. It sounds like a bug that was in IDS 7 Any Help would be appreciated! Thanks JohnAC
Download Process Explorer, crack it open, select the oninit process, and see
who/what is loaded into memory above it. You may be running into another
package.
j.
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf Of
John Chauvin
Sent: Wednesday, May 16, 2007 9:30 AM
To: ids@iiug.org
Subject: Informix Memory error on Windows [9165]
We are having an issue with IDS 9.4 on Windows 2000 and 2003 - if the
memory reaches around 1.8G the "on" commands stop working - we see
everything from "shared memory not initialized" to "cannot connect" with
no other information and the instance is running and if you are on the
system before it reaches this level you can still work.
We have duplicated this by setting either the SHMBASE or buffers up till
we get in the range of 1.8G Memory and it all stops.
IBM thinks it's a windows bug but I have nothing to take to MS. It
sounds like a bug that was in IDS 7
Any Help would be appreciated!
Thanks
JohnAC
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
Hi, 1.8GB is about your limit unless you use the /3GB boot.ini switch, in which case you should be able to get around 2.7GB. > IBM thinks it's a windows bug Please let me know the PMR number. BTW If you need more than 2.7GB you might want to consider signing up for the IDS 64-bit Windows beta. Regards Guy ----- Original Message ---- From: John Chauvin <John.Chauvin@mediware.com> To: ids@iiug.org Sent: Wednesday, May 16, 2007 6:30:00 AM Subject: Informix Memory error on Windows [9165] We are having an issue with IDS 9.4 on Windows 2000 and 2003 - if the memory reaches around 1.8G the "on" commands stop working - we see everything from "shared memory not initialized" to "cannot connect" with no other information and the instance is running and if you are on the system before it reaches this level you can still work. We have duplicated this by setting either the SHMBASE or buffers up till we get in the range of 1.8G Memory and it all stops. IBM thinks it's a windows bug but I have nothing to take to MS. It sounds like a bug that was in IDS 7 Any Help would be appreciated! Thanks JohnAC ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ________________________________________________________________________________ ____Get the Yahoo! toolbar and be alerted to new email wherever you're surfing. http://new.toolbar.yahoo.com/toolbar/features/mail/index.php
Thanks for the info we do have the /3G and have tried the /PAE as well no difference The PMR is 03177,370 SecureLinkTM The future of secure support. This message (including any attachments) constitutes a confidential communication and/or contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, please notify the sender by return email and delete this message and any attachments. Any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Guy . Sent: Wednesday, May 16, 2007 9:46 AM To: ids@iiug.org Subject: Re: Informix Memory error on Windows [9168] Hi, 1.8GB is about your limit unless you use the /3GB boot.ini switch, in which case you should be able to get around 2.7GB. > IBM thinks it's a windows bug Please let me know the PMR number. BTW If you need more than 2.7GB you might want to consider signing up for the IDS 64-bit Windows beta. Regards Guy ----- Original Message ---- From: John Chauvin <John.Chauvin@mediware.com> To: ids@iiug.org Sent: Wednesday, May 16, 2007 6:30:00 AM Subject: Informix Memory error on Windows [9165] We are having an issue with IDS 9.4 on Windows 2000 and 2003 - if the memory reaches around 1.8G the "on" commands stop working - we see everything from "shared memory not initialized" to "cannot connect" with no other information and the instance is running and if you are on the system before it reaches this level you can still work. We have duplicated this by setting either the SHMBASE or buffers up till we get in the range of 1.8G Memory and it all stops. IBM thinks it's a windows bug but I have nothing to take to MS. It sounds like a bug that was in IDS 7 Any Help would be appreciated! Thanks JohnAC ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ________________________________________________________________________ ____________Get the Yahoo! toolbar and be alerted to new email wherever you're surfing. http://new.toolbar.yahoo.com/toolbar/features/mail/index.php ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.
> Thanks for the info we do have the /3G In that case as Jack said Process Explorer should help. Will take a look at the PMR. Guy ----- Original Message ---- From: John Chauvin <John.Chauvin@mediware.com> To: ids@iiug.org Sent: Wednesday, May 16, 2007 8:04:18 AM Subject: RE: Informix Memory error on Windows [9170] Thanks for the info we do have the /3G and have tried the /PAE as well no difference The PMR is 03177,370 SecureLinkTM The future of secure support. This message (including any attachments) constitutes a confidential communication and/or contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, please notify the sender by return email and delete this message and any attachments. Any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Guy . Sent: Wednesday, May 16, 2007 9:46 AM To: ids@iiug.org Subject: Re: Informix Memory error on Windows [9168] Hi, 1.8GB is about your limit unless you use the /3GB boot.ini switch, in which case you should be able to get around 2.7GB. > IBM thinks it's a windows bug Please let me know the PMR number. BTW If you need more than 2.7GB you might want to consider signing up for the IDS 64-bit Windows beta. Regards Guy ----- Original Message ---- From: John Chauvin <John.Chauvin@mediware.com> To: ids@iiug.org Sent: Wednesday, May 16, 2007 6:30:00 AM Subject: Informix Memory error on Windows [9165] We are having an issue with IDS 9.4 on Windows 2000 and 2003 - if the memory reaches around 1.8G the "on" commands stop working - we see everything from "shared memory not initialized" to "cannot connect" with no other information and the instance is running and if you are on the system before it reaches this level you can still work. We have duplicated this by setting either the SHMBASE or buffers up till we get in the range of 1.8G Memory and it all stops. IBM thinks it's a windows bug but I have nothing to take to MS. It sounds like a bug that was in IDS 7 Any Help would be appreciated! Thanks JohnAC ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ________________________________________________________________________ ____________Get the Yahoo! toolbar and be alerted to new email wherever you're surfing. http://new.toolbar.yahoo.com/toolbar/features/mail/index.php ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ________________________________________________________________________________ ____Get the free Yahoo! toolbar and rest assured with the added security of spyware protection. http://new.toolbar.yahoo.com/toolbar/features/norton/index.php
I have found several discussions of using various addresses for the instances - even on IBM site they also do not work to fix this (use of 0x20000000L etc) the only one I have found was a discussion regarding setting it up to 0x50000000 which appears to have worked in a test environment John A. Chauvin Manager Technical Implementations Medication Management Division MEDIWARE INFORMATION SYSTEMS www.mediware.com Office: (913) 307 - 1029 Mobile: (913) 489 - 1054 Fax: (913) 307 - 1111 John.Chauvin@mediware.com SecureLinkTM The future of secure support. This message (including any attachments) constitutes a confidential communication and/or contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, please notify the sender by return email and delete this message and any attachments. Any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Guy . Sent: Wednesday, May 16, 2007 10:13 AM To: ids@iiug.org Subject: Re: Informix Memory error on Windows [9171] > Thanks for the info we do have the /3G In that case as Jack said Process Explorer should help. Will take a look at the PMR. Guy ----- Original Message ---- From: John Chauvin <John.Chauvin@mediware.com> To: ids@iiug.org Sent: Wednesday, May 16, 2007 8:04:18 AM Subject: RE: Informix Memory error on Windows [9170] Thanks for the info we do have the /3G and have tried the /PAE as well no difference The PMR is 03177,370 SecureLinkTM The future of secure support. This message (including any attachments) constitutes a confidential communication and/or contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, please notify the sender by return email and delete this message and any attachments. Any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Guy . Sent: Wednesday, May 16, 2007 9:46 AM To: ids@iiug.org Subject: Re: Informix Memory error on Windows [9168] Hi, 1.8GB is about your limit unless you use the /3GB boot.ini switch, in which case you should be able to get around 2.7GB. > IBM thinks it's a windows bug Please let me know the PMR number. BTW If you need more than 2.7GB you might want to consider signing up for the IDS 64-bit Windows beta. Regards Guy ----- Original Message ---- From: John Chauvin <John.Chauvin@mediware.com> To: ids@iiug.org Sent: Wednesday, May 16, 2007 6:30:00 AM Subject: Informix Memory error on Windows [9165] We are having an issue with IDS 9.4 on Windows 2000 and 2003 - if the memory reaches around 1.8G the "on" commands stop working - we see everything from "shared memory not initialized" to "cannot connect" with no other information and the instance is running and if you are on the system before it reaches this level you can still work. We have duplicated this by setting either the SHMBASE or buffers up till we get in the range of 1.8G Memory and it all stops. IBM thinks it's a windows bug but I have nothing to take to MS. It sounds like a bug that was in IDS 7 Any Help would be appreciated! Thanks JohnAC ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ________________________________________________________________________ ____________Get the Yahoo! toolbar and be alerted to new email wherever you're surfing. http://new.toolbar.yahoo.com/toolbar/features/mail/index.php ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ________________________________________________________________________ ____________Get the free Yahoo! toolbar and rest assured with the added security of spyware protection. http://new.toolbar.yahoo.com/toolbar/features/norton/index.php ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.
> I have found several discussions of using various addresses for the
instances - even on IBM site they also do not work to fix this (use of
0x20000000L etc)
Are you referring to SHMBASE?
The best value is the default 0xC000000. Any higher value will reduce the
total shared memory size you can use. The problem will be caused by a DLL
loaded at an address which fragments address space - unless there is something
which is preventing /3GB from being used.
1. Start IDS with a small configuration which works.
2. Run an onstat command which will hang around, like "onstat -i" for example.
3. Run Process Explorer and configure it to show you DLL load addresses for
the onstat.exe process ordered by address. Send the output of this and "onstat
-g seg" and your boot.ini contents to the PMR owner (and here if you like).
Regards
Guy
----- Original Message ----
From: John Chauvin <John.Chauvin@mediware.com>
To: ids@iiug.org
Sent: Thursday, May 17, 2007 7:19:08 AM
Subject: RE: Informix Memory error on Windows [9176]
I have found several discussions of using various addresses for the
instances - even on IBM site they also do not work to fix this (use of
0x20000000L etc) the only one I have found was a discussion regarding
setting it up to 0x50000000 which appears to have worked in a test
environment
John A. Chauvin
Manager Technical Implementations
Medication Management Division
MEDIWARE INFORMATION SYSTEMS
www.mediware.com
Office: (913) 307 - 1029
Mobile: (913) 489 - 1054
Fax: (913) 307 - 1111
John.Chauvin@mediware.com
SecureLinkTM The future of secure support.
This message (including any attachments) constitutes a confidential
communication and/or contains confidential information intended for a
specific individual and purpose, and is protected by law. If you are
not the intended recipient, please notify the sender by return email and
delete this message and any attachments. Any disclosure, copying, or
distribution of this message, or the taking of any action based on it,
is strictly prohibited.
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Guy .
Sent: Wednesday, May 16, 2007 10:13 AM
To: ids@iiug.org
Subject: Re: Informix Memory error on Windows [9171]
> Thanks for the info we do have the /3G
In that case as Jack said Process Explorer should help. Will take a look
at the PMR.
Guy
----- Original Message ----
From: John Chauvin <John.Chauvin@mediware.com>
To: ids@iiug.org
Sent: Wednesday, May 16, 2007 8:04:18 AM
Subject: RE: Informix Memory error on Windows [9170]
Thanks for the info we do have the /3G and have tried the /PAE as well
no difference
The PMR is 03177,370
SecureLinkTM The future of secure support.
This message (including any attachments) constitutes a confidential
communication and/or contains confidential information intended for a
specific individual and purpose, and is protected by law. If you are not
the intended recipient, please notify the sender by return email and
delete this message and any attachments. Any disclosure, copying, or
distribution of this message, or the taking of any action based on it,
is strictly prohibited.
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Guy .
Sent: Wednesday, May 16, 2007 9:46 AM
To: ids@iiug.org
Subject: Re: Informix Memory error on Windows [9168]
Hi,
1.8GB is about your limit unless you use the /3GB boot.ini switch, in
which case you should be able to get around 2.7GB.
> IBM thinks it's a windows bug
Please let me know the PMR number.
BTW If you need more than 2.7GB you might want to consider signing up
for the IDS 64-bit Windows beta.
Regards
Guy
----- Original Message ----
From: John Chauvin <John.Chauvin@mediware.com>
To: ids@iiug.org
Sent: Wednesday, May 16, 2007 6:30:00 AM
Subject: Informix Memory error on Windows [9165]
We are having an issue with IDS 9.4 on Windows 2000 and 2003 - if the
memory reaches around 1.8G the "on" commands stop working - we see
everything from "shared memory not initialized" to "cannot connect" with
no other information and the instance is running and if you are on the
system before it reaches this level you can still work.
We have duplicated this by setting either the SHMBASE or buffers up till
we get in the range of 1.8G Memory and it all stops.
IBM thinks it's a windows bug but I have nothing to take to MS. It
sounds like a bug that was in IDS 7
Any Help would be appreciated!
Thanks
JohnAC
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
________________________________________________________________________
____________Get
the Yahoo! toolbar and be alerted to new email wherever you're surfing.
http://new.toolbar.yahoo.com/toolbar/features/mail/index.php
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
________________________________________________________________________
____________Get
the free Yahoo! toolbar and rest assured with the added security of
spyware
protection.
http://new.toolbar.yahoo.com/toolbar/features/norton/index.php
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
________________________________________________________________________________
____Building a website is a piece of cake. Yahoo! Small Business gives you all
the tools to get online.
http://smallbusiness.yahoo.com/webhosting
Related threads
- Micro-pump is cool idea for future computer chips
- FW: Informix DBA
- How tu use a table on another Instance
- lock table in exclusive mode