sa******@gmail.com wrote:
Hi ,
Appreciate if someone can clarify if database Share Memory Limit
(2 GB ) in Unix 32 bit boxes is the top limit for all the databases
put together in a database or is it for each of the database in an
Instance
Thanks & regards
sadanjan
Hi Sadanjan,
This limit is per-database, you can have multiple active databases,
with each database using the 2GB limit on UNIX 32-bit instances (on
Windows 32-bit, the overall sum of memory used by DB2 is limited to the
2GB virtual memory limit, or 3GB using the special /3GB boot option).
However, depending on your particular OS (AIX/Linux/Solaris/HP-UX), you
might need to do some OS and DB2 tuning to be able to actually allocate
the full 2GB for the database. Also, this will limit the amount of
instance-wide shared memory (INSTANCE_MEMORY), and private memory
(stmtheap, applheapsz, etc) that can be allocated. If your databases
are already pushing close to this limit, you're probably better off
using the 64-bit version of DB2.
Cheers,
Liam.