Re: Need Stability on I5 1st edition on IDS 11.70.TC1IE
Posted in 2011
Are you saying I should have SHMTOTAL 6442450944 ?
Will the IDS stop if memory exceeds that number?
From: Fernando Nunes
Sent: Wednesday, September 21, 2011 5:12 AM
To: Bill Hamilton
Cc: informix-list@iiug.org
Subject: Re: Need Stability on I5 1st edition on IDS 11.70.TC1IE
It should not even start... You're saying that the memory limit is inferior to the initial memory allocation!
It would be interesting to see the online.log of the instance...
Regards
On Tue, Sep 20, 2011 at 6:06 PM, Bill Hamilton <garage_dba@hotmail.com> wrote:
Many Thanks. We will see if that helps.
I now have this in the config ...
RESIDENT -1
SHMBASE 0xc000000L
SHMVIRTSIZE 130624
SHMADD 26124
EXTSHMADD 26124
SHMTOTAL 6144
SHMVIRT_ALLOCSEG 0,3
Will the IDS stop if memory exceeds 6144kb ?
From: Alexandre Marini
Sent: Tuesday, September 20, 2011 11:25 AM
To: Bill Hamilton
Subject: Re: Need Stability on I5 1st edition on IDS 11.70.TC1IE
Sorry Bill, forget what I told you about SHMVIRT_ALLOCSEG, your setting must be fine.
Em 20/09/2011 11:40, Bill Hamilton escreveu:
I did not see anything about private memory cache on that page,
but I notice the limit on ram is 2g (I thought it was 1g) which is nice surprise.
Here are the things you asked for ...
# 800 through 40% of the value of SHMTOTAL
# SHMBASE - The shared memory base address; do not change
# SHMVIRTSIZE - The initial size, in KB, of the virtual
# SHMADD - The size, in KB, of additional virtual shared
# EXTSHMADD - The size, in KB, of each extension shared
# SHMTOTAL - The maximum amount of shared memory for IDS,
# SHMVIRT_ALLOCSEG - Controls when IDS adds a memory segment and
# SHMNOACCESS - A list of up to 10 memory address ranges
SHMBASE 0xc000000L
#SHMVIRTSIZE 32656
#SHMVIRTSIZE 113876
SHMVIRTSIZE 130624
SHMADD 8192
EXTSHMADD 8192
SHMTOTAL 0
SHMVIRT_ALLOCSEG 0,3
#SHMNOACCESS 0x70000000-0x7FFFFFFF
# DD_HASHMAX - The number of entries per pool.
DD_HASHMAX 10 # DUMPSHMEM - Controls shared memory dumps. Acceptable values
DUMPSHMEM 1
IBM Informix Dynamic Server Version 11.70.TC1IE -- On-Line -- Up 00:28:00 -- 217856 Kbytes
Server start-up environment:
Variable Value [values-list]
COMSPEC C:\\Windows\\system32\\cmd.exe
DBDELIMITER |
DBPATH .
DBPRINT lpr
DBTEMP /tmp
INFORMIXDIR C:\\Informix
[C:\\Informix]
[/usr/informix]
INFORMIXSERVER ol_informix1170
INFORMIXTERM terminfo
LC_COLLATE en_us.8859-1
LC_CTYPE en_us.8859-1
LC_MONETARY en_us.8859-1
LC_NUMERIC en_us.8859-1
LC_TIME en_us.8859-1
LKNOTIFY yes
LOCKDOWN no
NODEFDAC no
ONCONFIG onconfig.ol_informix1170
PATH C:\\Program Files\\ibm\\gsk8\\lib;C:\\Program Files\\ibm\\gsk8\\bin
;C:\\Informix\\bin;C:\\Windows\\system32;C:\\Windows;C:\\Windows
\\System32\\Wbem;C:\\Program Files\\Intel\\DMIX;C:\\Program File
s\\Informix\\bin;C:\\UT;C:\\inetpub\\wwwroot\\dlls;C:\\mystiq_bin
;C:\\Program Files\\Microsoft SDKs\\Windows\\v6.0A\\Bin;c:\\Wind
ows\\Microsoft.NET\\Framework\\v2.0.50727\\;C:\\Windows\\System3
2\\WindowsPowerShell\\v1.0\\
SERVER_LOCALE en_us.8859-1
TERM dumb
TERMCAP /etc/termcap
From: Alexandre Marini
Sent: Tuesday, September 20, 2011 10:04 AM
To: Bill Hamilton
Cc: informix-list@iiug.org Subject: Re: Need Stability on I5 1st edition on IDS 11.70.TC1IE
I see you´re trying to enable private memory cache on your cpu vp, and that´s a resource not available on IE editions....
(I read this on the original article of Mr Carlton Doe:
http://www.ibm.com/developerworks/data/library/techarticle/dm-0801doe/
Other things, could you post the following output of commands below?
1) onstat -c |grep SHM
2) onstat -g env
Best regards.
Em 20/09/2011 10:48, Bill Hamilton escreveu:
This concerns IBM Informix Dynamic Server Version 11.70.TC1IE Software Serial Number AAA#B000000.
We have a server running and Intel I5 1st edition with these specs http://ark.intel.com/products/43546?wapkw=core%20i5%20650
It has 4gb of physical ram.
The onconfig has this:
MULTIPROCESSOR 1
VPCLASS cpu,num=1
VP_MEMORY_CACHE_KB 53200
SINGLE_CPU_VP 0
Is that right?
onstat –g seg gave me this before last boot:
Segment Summary:
id key addr size ovhd class blkused blkfree
1381386241 52564801 c000000 47382528 504368 R 11563 5
1381386242 52564802 ed30000 133758976 784888 V 32656 0
1381386243 52564803 16cc0000 8388608 50200 V 2048 0
1381386244 52564804 174c0000 8388608 50200 V 2048 0
1381386245 52564805 17cc0000 8388608 50200 V 2048 0
1381386246 52564806 184c0000 8388608 50200 V 2048 0
1381386247 52564807 18cc0000 8388608 50200 V 2048 0
1381386248 52564808 194c0000 8388608 50200 V 2048 0
1381386249 52564809 19cc0000 8388608 50200 V 2048 0
1381386250 5256480a 1a4c0000 8388608 50200 V 2048 0
1381386251 5256480b 1acc0000 8388608 50200 V 2048 0
1381386252 5256480c 1b4c0000 8388608 50200 V 2048 0
1381386253 5256480d 1bcc0000 8388608 50200 V 2048 0
1381386254 5256480e 1c4c0000 8388608 50200 V 2048 0
1381386255 5256480f 1ccc0000 8388608 50200 V 2048 0
1381386256 52564810 1d4c0000 8388608 50200 V 2048 0
1381386257 52564811 1dcc0000 8388608 50200 V 2048 0
1381386258 52564812 1e4c0000 8388608 50200 V 2048 0
1381386259 52564813 1ecc0000 8388608 50200 V 2048 0
1381386260 52564814 1f4c0000 8388608 50200 V 1802 246
1381386261 52564815 1fcc0000 8388608 50200 V 1499 549
1381386262 52564816 204c0000 8388608 50200 V 1577 471
1381386263 52564817 20cc0000 8388608 50200 V 1627 421
1381386264 52564818 214c0000 8388608 50200 V 1536 512
1381386265 52564819 21cc0000 8388608 50200 V 1552 496
1381386266 5256481a 224c0000 8388608 50200 V 1484 564
1381386267 5256481b 22cc0000 8388608 50200 V 1497 551
1381386268 5256481c 234c0000 8388608 50200 V 1589 459
1381386269 5256481d 23cc0000 8388608 50200 V 1691 357