Sue,
Unless you have an issue where the size of your memory constructs, like bufferpools or sortheap, are constrained within the 2 GB allowed by 32-bit addressing, there's no reason to switch. Actually, you get a bit less than 2 GB, more like 1.75 pr even 1.5. but in many cases that's enough.
If you switch the instance to 64-bit addressing, then you have so much potential address space that it can be dangerous the other way. Because paging/swapping technology has not caught up with the amount of memory allowed by 64-bit addressing, I sometimes joke that what you really get is 37.5-bit addressing. This is just my way of warning you not to make the sum of your memory constructs exceed the real memory on your server or you'll trade DB2 memory performance issues for OS swapping performance issues.
Regards,
Harv Shapiro
DB2 Database Administrator
Information Technology
-------------------------------------
Voice: 805.564.6384
Fax: 805.560.1687
Email: Harvey.[Email address protected]
--------------------------------------
Pacific Capital Bancorp
Mail Stop 96-11
490 S. Fairview Avenue, Suite 110
Santa Barbara, CA 93160-1007
>>> "Sheuehua" <db2udbdba-ezmlmshield-x48637148.[Email address protected] 1/17/2008 7:37:59 AM >>>
HI all,
Our DB2UDB V8.2 (FP15) database is running on AIX 5.2 32 bits
and does anyone know if we migrate to 64bits
how good about it?
I only know the db2 will run above the line and what good about it and do
we really need to go to 64 bits?
Thanks in advance !!
Sue
**********************************************************************
This e-mail transmission and any attachments that accompany it may
contain information that is privileged, confidential or otherwise
exempt from disclosure under applicable law and is intended solely for
the use of the individual(s) to whom it was intended to be addressed.
If you have received this e-mail by mistake, or you are not the
intended recipient, any disclosure, dissemination, distribution,
copying or other use or retention of this communication or its
substance is prohibited. If you have received this communication in
error, please immediately reply to the author via e-mail that you
received this message by mistake and also permanently delete the
original and all copies of this e-mail and any attachments from your
computer. Thank you.
**********************************************************************
---------------------------------------------------------------------
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
******************************************************************************
This e-mail is intended only for the use of the individual or entity
to which it is addressed and may contain information which is
privileged, confidential, and exempt from disclosure under applicable
law. If you are not the intended recipient, or an employee or agent
of the intended recipient, you are hereby notified that any
dissemination, distribution, or copying of this communication is
strictly prohibited. If you have received this communication in error
please notify us immediately by replying to [Email address protected]
******************************************************************************
**************************************************************************************
This e-mail is intended only for the use of the individual or entity
to which it is addressed and may contain information which is
privileged, confidential, and exempt from disclosure under applicable
law. If you are not the intended recipient, or an employee or agent
of the intended recipient, you are hereby notified that any
dissemination, distribution, or copying of this communication is
strictly prohibited. If you have received this communication in error
please notify us immediately by replying to [Email address protected]
**************************************************************************************
DB2 & UDB email list listserv db2-l LazyDBA home page