Hi,
Addressable memory in a 32-bit architecture versus 64-bit architecture
If you have a 64-bit DB2 instance that means DB2 is using the 64-bit memory
architecture. With this architecture, the address space of each process is 2
to the power of 64, or 18,446,744,073 GB, on all platforms. This is a huge
amount of memory. You should have no problem fitting all the DB2 memory sets
into this address space.
On the other hand, if you have a 32-bit DB2 instance, the address space is
only 2 to the power of 32, or 4 GB, on all platforms (except on Linux/390,
the address space is actually 2 to the power of 31. So regardless how big
your physical RAM is, for a DB2 process to be able to access all the
resources it needs, the instance shared memory, database shared memory, and
application group shared memory, its own agent private memory plus memory
for the kernel, etc, all have to fit into this 4GB address space.
Sanjay Rana
-----Original Message-----
From: NG YUNE CHONG
[mailto:db2udbdba-ezmlmshield-x92588854.[Email address protected]
Sent: Monday, November 26, 2007 11:47 AM
To: LazyDBA Discussion
Subject: Physical and OS Memory for bufferpool
Hi,
IBM DB2 bufferpool memory setup. I found that hardware physical memory
got 6 GB, But OS Windows 2003 only display 3.25 GB. Can I setup the
bufferpool base on physical memory?
Thanks in advance,
- Powered by TIME dotNet Berhad -
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DISCLAIMER
==========
This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.
DB2 & UDB email list listserv db2-l LazyDBA home page