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

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

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


Chris Bannister a écrit :
On Wed, Mar 26, 2008 at 09:46:19AM +0100, cypherstrong wrote:

I have already try to change it manually but DB2 auto rewrite the shmmax
value


Even in redhat? But it works in redhat?


I have try to start db2 and after set the shmmax, but they still crash
with same error.


Annoying.


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


Presuming you paid for this software, what does support have to say?


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


I don't know about db2. I use postgreSQL and it works out of the box.




Attachment: signature.asc
Description: OpenPGP digital signature

Relevant Pages

  • Re: IBM DB2 V9.5 32 bits failed to allocate share memory
    ... I have found that DB2 V9.5 ... Redhat sets automatically some sysctl value after installation: ... I have do the same tuning on debian, and now installation work but ... ... Even system doesn't say that they is some issues in memory, ...
    (Debian-User)
  • Re: errors calling linked oleDB server stored procedures
    ... The remote database is not DB2, ... So I am not sure whether the provider you used could support ... would you please try to call a stored procedure without dynamic ...
    (microsoft.public.sqlserver.programming)
  • Re: Codepage 37 vs 1047
    ... What about UK DB2 shops. ... CICS will support the integrated compiler for C/C++. ... For IBM-MAIN subscribe / signoff / archive access instructions, ... send email to listserv@xxxxxxxxxxx with the message: GET IBM-MAIN INFO ...
    (bit.listserv.ibm-main)
  • Re: Theoretical Basis for SELECT FOR UPDATE
    ... but you DON'T need the full works of multi-versioning just to ... I imagine DB2 et al already have something like that?" ... > memory". ... >> can at least speculate on how it might be implemented. ...
    (comp.databases.theory)
  • Re: DB2 Data Bases and Central Storage
    ... Some of our DB2 folkes have been asking us and we cannot see why they would want to do that since we have physical constraints. ... I am not sure how I would extrapolate out how much more memory would be needed, or page datasets, etc. ... How big are the tables they want to put in storage? ... We create a couple new 4K buffer pools, made them bigger than the 2 pools we were using and moved some of our heavest hitting index files and table spaces to these pools. ...
    (bit.listserv.ibm-main)