Unix Technical Forum

Memory limits for DB2 V8 on LINUX

This is a discussion on Memory limits for DB2 V8 on LINUX within the DB2 forums, part of the Database Server Software category; --> Is anybody out there pushing the memory limits ( for shared memory ) with DB2 version 8 on LINUX. ...


Go Back   Unix Technical Forum > Database Server Software > DB2

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-26-2008, 05:39 PM
Matthew Dauphinee
 
Posts: n/a
Default Memory limits for DB2 V8 on LINUX

Is anybody out there pushing the memory limits ( for shared memory )
with DB2 version 8 on LINUX. The Advanced Admin IBM Press Book
claims that kernel 2.4 can only grab 1.75 GB. We have just gotten
RedHat Enterprise Linux AS release 3 ( kernel 2.4.21-9.0.1.ELcustom)
and just by trying sizes, it looks like it can address an eyelash
smaller than 4 GB. I don't know if I should trust it for production
use. Does anybody have experience with that? I just don't trust it
yet.

Matt
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-26-2008, 05:39 PM
Blair Adamache
 
Posts: n/a
Default Re: Memory limits for DB2 V8 on LINUX

With SuSE SLES 8 service pack 2 and DB2 v8.1 FixPak 2 or later, extra
memory can be used for bufferpools for a maximum of about 2.2GB.

If you want to use more memory, buy a 64-bit AMD or Intel chip - DB2
Linux supports 64-bit memory addressabiltiy on both of those platforms.

Matthew Dauphinee wrote:

> Is anybody out there pushing the memory limits ( for shared memory )
> with DB2 version 8 on LINUX. The Advanced Admin IBM Press Book
> claims that kernel 2.4 can only grab 1.75 GB. We have just gotten
> RedHat Enterprise Linux AS release 3 ( kernel 2.4.21-9.0.1.ELcustom)
> and just by trying sizes, it looks like it can address an eyelash
> smaller than 4 GB. I don't know if I should trust it for production
> use. Does anybody have experience with that? I just don't trust it
> yet.
>
> Matt


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 02-26-2008, 05:40 PM
Matthew Dauphinee
 
Posts: n/a
Default Re: Memory limits for DB2 V8 on LINUX

Blair,

That makes complete sense to me, but our management isn't very
interested in 64 bit computing yet. Painful.

Well if anyone else is seeing upwards of 3.5GB bufferpools on 32 bit
Intel machines running LINUX, I'd like to hear about it.

Matt


Blair Adamache <badamache@nospamtodaysiryahoo.com> wrote in message news:<40735022.504595E0@nospamtodaysiryahoo.com>.. .
> With SuSE SLES 8 service pack 2 and DB2 v8.1 FixPak 2 or later, extra
> memory can be used for bufferpools for a maximum of about 2.2GB.
>
> If you want to use more memory, buy a 64-bit AMD or Intel chip - DB2
> Linux supports 64-bit memory addressabiltiy on both of those platforms.
>
> Matthew Dauphinee wrote:
>
> > Is anybody out there pushing the memory limits ( for shared memory )
> > with DB2 version 8 on LINUX. The Advanced Admin IBM Press Book
> > claims that kernel 2.4 can only grab 1.75 GB. We have just gotten
> > RedHat Enterprise Linux AS release 3 ( kernel 2.4.21-9.0.1.ELcustom)
> > and just by trying sizes, it looks like it can address an eyelash
> > smaller than 4 GB. I don't know if I should trust it for production
> > use. Does anybody have experience with that? I just don't trust it
> > yet.
> >
> > Matt

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 02-26-2008, 05:40 PM
Bob Jones
 
Posts: n/a
Default Re: Memory limits for DB2 V8 on LINUX


"Matthew Dauphinee" <mdauphinee@performics.com> wrote in message
news:41acab23.0404070727.3cbd9aab@posting.google.c om...
> Blair,
>
> That makes complete sense to me, but our management isn't very
> interested in 64 bit computing yet. Painful.
>
> Well if anyone else is seeing upwards of 3.5GB bufferpools on 32 bit
> Intel machines running LINUX, I'd like to hear about it.
>
> Matt
>


We run DB2 on Red Hat AS 2.1. The maximum buffer pool size per instance is
slightly less than 2G. That's sufficient for most databases. You can always
configure extended storage, if you need more.

I have not used AS 3.0. Maybe the limit has been increased in this release.


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 02-26-2008, 05:40 PM
Jean-David Beyer
 
Posts: n/a
Default Re: Memory limits for DB2 V8 on LINUX

Bob Jones wrote:
> "Matthew Dauphinee" <mdauphinee@performics.com> wrote in message
> news:41acab23.0404070727.3cbd9aab@posting.google.c om...
>
>>Blair,
>>
>>That makes complete sense to me, but our management isn't very
>>interested in 64 bit computing yet. Painful.
>>
>>Well if anyone else is seeing upwards of 3.5GB bufferpools on 32 bit
>>Intel machines running LINUX, I'd like to hear about it.
>>
>>Matt
>>

>
>
> We run DB2 on Red Hat AS 2.1. The maximum buffer pool size per instance is
> slightly less than 2G. That's sufficient for most databases. You can always
> configure extended storage, if you need more.
>
> I have not used AS 3.0. Maybe the limit has been increased in this release.
>
>

I have ES 3.0, but do not have DB2 installed (I have only DB2 V6.1, and
I know I will have real dependency problems with it were I to try). When
I read Red Hat stuff, I infer that each process should be able to access
3.7 to 3.8 GBytes provided you have enough real memory and a chipset
(e.g., Intel E7501) to support it.

https://www.redhat.com/apps/WebForm/...paperfinal.pdf

implies it, but this link may require registration to see it.

--
.~. Jean-David Beyer Registered Linux User 85642.
/V\ Registered Machine 241939.
/( )\ Shrewsbury, New Jersey http://counter.li.org
^^-^^ 22:30:00 up 6 days, 18:45, 2 users, load average: 4.10, 4.06, 4.01

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:18 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com