RE: How to minimize the CPU utilization while DB2 processing

RE: How to minimize the CPU utilization while DB2 processing

 

  

CPU= size (of all bufferpool) + size (of dbheap) + size (of sortheap) + size (of packagesz) + size (of utl_heap_sz) + size ( (of ASLHEAPSZ) + size (locklist) + size (applheapsz) + 5% of all

-----Message d'origine-----
De : SaiPrasad
[mailto:db2udbdba-ezmlmshield-x36565504.[Email address protected]
Envoyé : mercredi 27 octobre 2004 08:50
À : LazyDBA Discussion
Objet : Fw: How to minimize the CPU utilization while DB2 processing


hi
I hv DB2 version 8 running in AIX server.

Usually whn the db2 is started, CPU utilization comes to 100% in server.

So is thre any possibility to find wht are the applications gets started
with db2 and to
minimize the cpu utilization.

regards
saiprasad
Millienium software productions
chennai




---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


DB2 & UDB email list listserv db2-l LazyDBA home page