Re: IBM DB2 V9.5 32 bits failed to allocate share memory
On Thu, Apr 03, 2008 at 11:54:53AM +0200, cypherstrong wrote:
> Ok After well testing on both system ... I have found that DB2 V9.5
> FixPack 0 doesn't work on 32 bits system properly
> Redhat sets automatically some sysctl value after installation:
>
> kernel.shmmax
>
> So that's why db2 don't crash
>
> I have do the same tuning on debian, and now installation work but ...
> performance is awfull !!!
>
> Even system doesn't say that they is some issues in memory, it seems db2
> has a problem on 32bits system...
>
> So I have try v8.2 version, and speed is wonderfull with same tuneage of
> memory
> I do this :
>
>
> kernel.sem = 256 256000 100 1024
> kernel.shmmax=256M (in octet so)
> kernel.shmall=3.7G
>
> So speed is excellent with older version of db2 but not this version,
> even in redhat or debian
>
> I have post on db2 my issue, but it seems that nobody use this version
> yet on net ...
>
> I can't download v9.1fixpack4 anymore on db2 (link is really well hide
> on they site)
>
> So I'm stuck for this system
>
> We will need to move to a 64 bits system to solve the problem
>
> a fixpack 1 should be good now
>
> thanks for support
No problem. Seems like its not a Debian problem then.
But I would check the kernel configs for differences.
--
Chris.
======
Reply to: