Discussion:
Informix Memory Problem in Windows 2008 bits
(too old to reply)
a***@gmail.com
2016-05-29 13:46:29 UTC
Permalink
Raw Message
Hi, we have a performance issue in our production environement, when we've checked the online log we found that informix is allocating each time memory segment of 82223 kb to 82260 kb and so on, so we have change onconfig parameters to :
SHMVIRTSIZE TO 20000000
SHMADD TO 1000000
SHMTOTAL TO 25000000

our server is a Window 2008 64 bits with 53 GB and 16 cpu, but we restarted the informix server we have check the memory of the server and its consuming just 1.8 GB of resident memory even if we gave it 20 Gb in onconfig, so why Informix does not reserve the memory I gave in the onconfig wich is 20000000.

is there any problem with window 2008 64 bits, my Informix is 11.70 TC5

Thanks
Mike Walker
2016-05-29 14:23:54 UTC
Permalink
Raw Message
Are there any messages in the Informix log on startup to show that
SHMVIRTSIZE was changed, and why the setting may have been overridden?

-----Original Message-----
From: informix-list-***@iiug.org [mailto:informix-list-***@iiug.org]
On Behalf Of ***@gmail.com
Sent: Sunday, May 29, 2016 7:46 AM
To: informix-***@iiug.org
Subject: Informix Memory Problem in Windows 2008 bits

Hi, we have a performance issue in our production environement, when we've
checked the online log we found that informix is allocating each time memory
segment of 82223 kb to 82260 kb and so on, so we have change onconfig
parameters to :
SHMVIRTSIZE TO 20000000
SHMADD TO 1000000
SHMTOTAL TO 25000000

our server is a Window 2008 64 bits with 53 GB and 16 cpu, but we restarted
the informix server we have check the memory of the server and its consuming
just 1.8 GB of resident memory even if we gave it 20 Gb in onconfig, so why
Informix does not reserve the memory I gave in the onconfig wich is
20000000.

is there any problem with window 2008 64 bits, my Informix is 11.70 TC5

Thanks
a***@gmail.com
2016-05-29 19:31:55 UTC
Permalink
Raw Message
Hi, I have found how to fix the memory, in fact We have gave 6 Gb for SHMVIRTSIZE and thrue large query the informix has reach 17 GB but it was adding virtual segments for long time and here we are the performance has been impacted, I plan to fix the SHMVIRTSIZE to 20 GB snce I have 53 GB in my Windows, I have thought that its a Windows problem but its not, it was under estimaed in onconfig SHMVIRTSIZE parameter, but I have a quastion should I fix resident to -1 or let it 0 ? whats is the advantage of fixing Resident memory
Mike Walker
2016-05-29 17:06:45 UTC
Permalink
Raw Message
I found this in the machine notes, which may describe the problem that you
are having:


2. Support maximum shared memory

The database server can access shared-memory larger than two gigabytes
on Windows. However, you must enable this feature with an entry in the
Windows boot file.

To add the entry, edit the boot.ini file (located in the top level, or
root directory). You can either add a new boot option or use the
currently
existing boot option. To enable support for more than two gigabytes, add

the following text to the end of the boot line:

/3GB



-----Original Message-----
From: informix-list-***@iiug.org [mailto:informix-list-***@iiug.org]
On Behalf Of Mike Walker
Sent: Sunday, May 29, 2016 8:24 AM
To: ***@gmail.com; informix-***@iiug.org
Subject: RE: Informix Memory Problem in Windows 2008 bits

Are there any messages in the Informix log on startup to show that
SHMVIRTSIZE was changed, and why the setting may have been overridden?

-----Original Message-----
From: informix-list-***@iiug.org [mailto:informix-list-***@iiug.org]
On Behalf Of ***@gmail.com
Sent: Sunday, May 29, 2016 7:46 AM
To: informix-***@iiug.org
Subject: Informix Memory Problem in Windows 2008 bits

Hi, we have a performance issue in our production environement, when we've
checked the online log we found that informix is allocating each time memory
segment of 82223 kb to 82260 kb and so on, so we have change onconfig
parameters to :
SHMVIRTSIZE TO 20000000
SHMADD TO 1000000
SHMTOTAL TO 25000000

our server is a Window 2008 64 bits with 53 GB and 16 cpu, but we restarted
the informix server we have check the memory of the server and its consuming
just 1.8 GB of resident memory even if we gave it 20 Gb in onconfig, so why
Informix does not reserve the memory I gave in the onconfig wich is
20000000.

is there any problem with window 2008 64 bits, my Informix is 11.70 TC5

Thanks
a***@gmail.com
2016-05-29 19:28:53 UTC
Permalink
Raw Message
Post by Mike Walker
I found this in the machine notes, which may describe the problem that you
2. Support maximum shared memory
The database server can access shared-memory larger than two gigabytes
on Windows. However, you must enable this feature with an entry in the
Windows boot file.
To add the entry, edit the boot.ini file (located in the top level, or
root directory). You can either add a new boot option or use the
currently
existing boot option. To enable support for more than two gigabytes, add
/3GB
-----Original Message-----
On Behalf Of Mike Walker
Sent: Sunday, May 29, 2016 8:24 AM
Subject: RE: Informix Memory Problem in Windows 2008 bits
Are there any messages in the Informix log on startup to show that
SHMVIRTSIZE was changed, and why the setting may have been overridden?
-----Original Message-----
Sent: Sunday, May 29, 2016 7:46 AM
Subject: Informix Memory Problem in Windows 2008 bits
Hi, we have a performance issue in our production environement, when we've
checked the online log we found that informix is allocating each time memory
segment of 82223 kb to 82260 kb and so on, so we have change onconfig
SHMVIRTSIZE TO 20000000
SHMADD TO 1000000
SHMTOTAL TO 25000000
our server is a Window 2008 64 bits with 53 GB and 16 cpu, but we restarted
the informix server we have check the memory of the server and its consuming
just 1.8 GB of resident memory even if we gave it 20 Gb in onconfig, so why
Informix does not reserve the memory I gave in the onconfig wich is
20000000.
is there any problem with window 2008 64 bits, my Informix is 11.70 TC5
Thanks
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list
No, its obnly for Windows 2003, in 2008 there is o more boot.ini file
Loading...