It depends on the application. If you have a huge set of dynamic SQL, then
the package cache is very valuable and if
you have poorly coded applications (that dont commit) then locklist needs
to be increased.
"Zarier Behardien "
<db2udbdba-ezmlmshield-x25425306.[Email address protected]
03/20/2008 09:55 AM
To
"LazyDBA Discussion" <[Email address protected]
cc
Subject
RE: Memory Allocation in 32 bit UDB Env
Thanks,
I just have 2 Questions regarding the allocation of
pckcachesz
and
Locklist
Is it necessary to allocate so much memory to these parameters, would the
memory not be better utilised being allocated to buferpools.
Your thoughts on this.
UDFS
mmap
The above parameters, utilise a memory segment of 256 mb each, thats
available to the shared database memory.
In a transactional database environment, how would this setting be
effective as it limits the available shared memory
to be allocated to other resources of a total of 1.75 gb.
I would appreciate your thoughts on this, or am I missing the point.
Kind regards
Zarier Behardien
________________________________
From: DANIEL CALLAHAN [mailto:[Email address protected]
Sent: Thu 3/20/2008 2:22 PM
To: Zarier Behardien
Subject: RE: Memory Allocation in 32 bit UDB Env
enclosed is a spreadsheet for shared memory on AIX.
Dan Callahan Senior Certified IT Specialist
603-472-4121 t/l 525-4121
[Email address protected]
"Zarier Behardien" <Zarier.[Email address protected]
03/20/2008 03:15 AM
To
DANIEL CALLAHAN/Bedford/[Email Address Removed]
cc
Subject
RE: Memory Allocation in 32 bit UDB Env
Thanks Daniel, appreciate the response.
It helps alot :o)
Regards
Zarier
________________________________
From: DANIEL CALLAHAN [mailto:[Email address protected]
Sent: Wed 3/19/2008 9:05 PM
To: Zarier Behardien
Subject: RE: Memory Allocation in 32 bit UDB Env
For shared memory , its 2 GB (more likely 1.75) per instance. For real
memory you can get up to whats in the box.
"Zarier Behardien" <Zarier.[Email address protected]
03/19/2008 09:44 AM
To
DANIEL CALLAHAN/Bedford/[Email Address Removed]
cc
Subject
RE: Memory Allocation in 32 bit UDB Env
AIX 5.3 ML 4
________________________________
From: DANIEL CALLAHAN [mailto:[Email address protected]
Sent: Wed 3/19/2008 2:19 PM
To: Zarier Behardien
Subject: Re: Memory Allocation in 32 bit UDB Env
**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text
it depends on the OS. What are you using?
"Zarier Behardien "
[Email address protected]
03/19/2008 05:59 AM
To
"LazyDBA Discussion" [Email address protected]
cc
Subject
Memory Allocation in 32 bit UDB Env
Hi,
I would like to know,
We have 1 database server running DB2 UDB Enterprise Edition with a total
of 20 databases across 7 Instances.
is the limit of memory that can be allocated to UDB, 4GB across All
instances and it's databases or is it 4gb per instance.
Any feedback will be much appreciated.
Thanks
Zarier
This message and/or attachment(s) may contain privileged or confidential
information. If you are not the intended recipient you may not disclose or
distribute any of the information contained within this message. In such
case you must destroy this message and inform the sender of the error.
T-Systems does not accept liability for any errors, omissions, information
and viruses contained in the transmission of this message. Any opinions,
conclusions and other information contained within this message not
related
to T-Systems' official business is deemed to be that of the individual
only
and is not endorsed by T-Systems.
T-Systems - Business Flexibility
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com <http://jobs.lazydba.com/>
To Subscribe : http://www.LazyDBA.com <http://www.lazydba.com/>
To unsubscribe: http://www.lazydba.com/unsubscribe.html <
http://www.lazydba.com/unsubscribe.html>
This message and/or attachment(s) may contain privileged or confidential
information. If you are not the intended recipient you may not disclose or
distribute any of the information contained within this message. In such
case you must destroy this message and inform the sender of the error.
T-Systems does not accept liability for any errors, omissions, information
and viruses contained in the transmission of this message. Any opinions,
conclusions and other information contained within this message not
related to T-Systems' official business is deemed to be that of the
individual only and is not endorsed by T-Systems.
T-Systems - Business Flexibility
This message and/or attachment(s) may contain privileged or confidential
information. If you are not the intended recipient you may not disclose or
distribute any of the information contained within this message. In such
case you must destroy this message and inform the sender of the error.
T-Systems does not accept liability for any errors, omissions, information
and viruses contained in the transmission of this message. Any opinions,
conclusions and other information contained within this message not
related to T-Systems' official business is deemed to be that of the
individual only and is not endorsed by T-Systems.
T-Systems - Business Flexibility
This message and/or attachment(s) may contain privileged or confidential
information. If you are not the intended recipient you may not disclose or
distribute any of the information contained within this message. In such
case you must destroy this message and inform the sender of the error.
T-Systems does not accept liability for any errors, omissions, information
and viruses contained in the transmission of this message. Any opinions,
conclusions and other information contained within this message not
related
to T-Systems' official business is deemed to be that of the individual
only
and is not endorsed by T-Systems.
T-Systems - Business Flexibility
---------------------------------------------------------------------
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
DB2 & UDB email list listserv db2-l LazyDBA home page