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 Chris Bannister a écrit : > On Mon, Mar 31, 2008 at 05:22:13PM +0200, cypherstrong wrote: > >> Ok in fact what I have saw is this >> >> First, db2 start with 256m share memory ... >> So it's ok, they are be able to do it on both system >> >> Second, they try to change by following the memory of the system >> On redhat, it's ok >> On debian, they don't do it properly >> Perhaps it set a too high value >> > > Sounds like Redhat + the db2 guys are hand in glove. > > Does a search on google with, e.g, db2 Debian, as the search terms bring > up any thing interesting, or even db2 linux > > Or probably even better: db2 linux shmmax :-) > > >> I have try the express version, so no support for that I think >> I could try to ask >> >> I'm waiting for a new version of db2 >> I will see if the problem persist >> >> Thanks for support >> > > No problem, hopefully you at least can sleep a little better. :-) > >
Attachment:
signature.asc
Description: OpenPGP digital signature