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

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

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


	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.


Reply to: