[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: IBM DB2 V9.5 32 bits failed to allocate share memory



I have already try to change it manually but DB2 auto rewrite the shmmax
value
I have try to start db2 and after set the shmmax, but they still crash
with same error.

Perhaps it's a bug of the db2 v9.5 fixpack 0 of ibm soft because older
version work fine without anything to do.

They is a way to tell to db2 to don't change this value himself ?

Chris Bannister a écrit :
> On Tue, Mar 25, 2008 at 09:51:23AM +0100, Strong Cypher wrote:
>   
>> Hi,
>>
>> Thanks for answer
>>
>> So here all collection I can do to find the problem :
>>
>> Yeah there is some difference ... perhaps I could try to copy the kernel
>> config of redhat on a debian with the same version of kernel and see ... I
>> will try that
>>     
>
> Maybe, but see below.
>
>   
>> So here the DB2 log
>>     
> [..]
>   
>> MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
>>           "No Storage Available for allocation"
>>     
>              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>   
>>           DIA8305C Memory allocation failure occurred.
>> DATA #1 : <preformatted>
>> Unable to attach 3 segments totalling 566165504 bytes starting at address
>> 0x00000000.  One possible cause may be an improper setting for the
>> shmmax Linux kernel tuneable.
>>     
>   ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> Here is your clue, right there.
>
>   
>> ... So the problem appear during the installation process ... I have never
>> see that on the redhat system
>>     
>
> compare:
>
> 	cat /proc/sys/kernel/shmmax
>
> on the Debian system with the redhat system.
>
> To alter the setting, e.g.:
>
> 	echo 1000000000 > /proc/sys/kernel/shmmax
>
> will allow a segment up to one billion bytes.
>
> The error (from above):
>
> 	Unable to attach 3 segments totalling 566165504 bytes
>
> will help determine the value.
>
> If you reboot your computer, you will lose that setting so you will have
> to put it in a local init script.
>
>   


Attachment: signature.asc
Description: OpenPGP digital signature


Reply to: