Re: Need Stability on I5 1st edition on IDS 11.70.TC1IE
The memory you specify in SHMTOTAL and SHMVIRTSIZE is specified in KBytes.
The memory shown in onstat -g seg in in bytes
Informix ideally will not stop when you reach SHMTOTAL, but it's hard to
handle low memory conditions (sometimes to rollback you need more memory for
example).
This is the reason why in 11.70.FC3 and 11.50.FC9 IBM introduced the "LOW
MEMORY feature".
As I was saying, it should not stop, but it's possible/probable that you'll
have problems.
Again, your online.log should be interesting to see. I suppose it's changing
the values you give, since they're not acceptable. And any messages at
"unavailability time" would be most interesting.
Regards.
On Wed, Sep 21, 2011 at 2:30 PM, Bill Hamilton <garage_dba@hotmail.com>wrote:
> Are you saying I should have SHMTOTAL 6442450944 ?
> Will the IDS stop if memory exceeds that number?
>
> *From:* Fernando Nunes <domusonline@gmail.com>
> *Sent:* Wednesday, September 21, 2011 5:12 AM
> *To:* Bill Hamilton <garage_dba@hotmail.com>
> *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 <amarini@fazenda.ms.gov.br>
>> *Sent:* Tuesday, September 20, 2011 11:25 AM
>> *To:* Bill Hamilton <garage_dba@hotmail.com>
>> *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 <amarini@fazenda.ms.gov.br>
>> *Sent:* Tuesday, September 20, 2011 10:04 AM
>> *To:* Bill Hamilton <garage_dba@hotmail.com>
>> *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