Hi,

I'm curious how people decide the amount of memory available to db2.
For example, we have a machine running AIX 5.3 with 32GB of memory.
Assuming that the machine is dedicated to DB2 how much memory can DB2
use on this box without incurring paging? Does anyone know of any rule
of thumb for this, especially for AIX?

Lew

<sethwai@yahoo.com> wrote in message
news:1169234720.638721.95280@l53g2000cwa.googlegro ups.com...
> Hi,
>
> I'm curious how people decide the amount of memory available to db2.
> For example, we have a machine running AIX 5.3 with 32GB of memory.
> Assuming that the machine is dedicated to DB2 how much memory can DB2
> use on this box without incurring paging? Does anyone know of any rule
> of thumb for this, especially for AIX?
>
> Lew

Depends on whether you have created a 32-bit or 64-bit DB2 instance (all AIX
instances on V9 are 64 bit). If 32-bit, the maximum is about 2GB.

To check your instance bit size, issue db2level command.