Memory limits for DB2 V8 on LINUX

Matthew Dauphinee

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

Nov 12 '05 #1

Subscribe Post Reply

2016

Blair Adamache

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

Nov 12 '05 #2

Matthew Dauphinee

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 <ba*******@nospamtodaysiryahoo.com> wrote in message news:<40***************@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

Nov 12 '05 #3

Bob Jones

"Matthew Dauphinee" <md********@performics.com> wrote in message
news:41**************************@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.

Nov 12 '05 #4

Jean-David Beyer

Bob Jones wrote:

"Matthew Dauphinee" <md********@performics.com> wrote in message
news:41**************************@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

Nov 12 '05 #5

Similar topics

hard memory limits

by: Maurice LING | last post by:

Hi, I think I've hit a system limit in python when I try to construct a list of 200,000 elements. My error is malloc: vm_allocate (size = 2400256) failed...... Just wondering is this...

Python

Memory and bufferpool issues

by: Yoyoma | last post by:

Hello, I have a client running db2 udb 7.2 workgroup , FP10a on a Windows 200 server with 4GB of memory. The database is 25GB big, but from that maybe 50% is current data. My issue is that we...

DB2 Database

the maximum memory size allowed in malloc

by: Jerry | last post by:

I am wondering what is the maximum size of memory that malloc() could handle. Is there any limitation on that? Where am I supposed to get this kind of information? Thank you everybody.

C / C++

Memory management and allocation

by: Dan Nilsen | last post by:

Hi! I'm writing a small piece of software that basically runs on an embedded system with a Power-PC cpu. This runs on a stripped down version of Linux - Busybox. As I'm writing a piece of...

C / C++

Code Review? memory management in C

by: Pedro Graca | last post by:

I have a file with different ways to write numbers ---- 8< (cut) -------- 0: zero, zilch,, nada, ,,,, empty , void, oh 1: one 7: seven 2: two, too ---- >8 -------------- ...

C / C++

Different Variables Use Same Memory

by: MajorSetback | last post by:

I am using the Redhat version of Linux and GNU C++. It is not clear to me whether this is a Linux issue or a C++ issue. I do not have this problem running the same program on Windows but...

C / C++

how to find available memory in linux box

by: david wolf | last post by:

I have a problem that is used to test memory leak as follows, however, after each run of the program, if I am using the command "free" on the linux box, I did not see any difference about the...

C / C++

Process and its memory Limit. (Linux biased)

by: Nehil | last post by:

When a process is started three segments are created : 1) Text. 2) Stack. 3) Data. The size of First two is fixed and their upperlimit is fixed by the compiler. (Plz correct if i'm wrong) Now...

C / C++

32-bit python memory limits?

by: Gary Robinson | last post by:

I'm running a Python job on OS X 10.5.3 and the Python 2.5.2 that's available as a binary download at python.org for OS X. I ran a python program tonight that ended up using much more memory than...

Python

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA