How to confirm DB2 DB CPU (and Memory) is optimally used.

Deb Kumar

How to confirm DB2 DB CPU (and Memory) is optimally used.

How to confirm DB2 LUW DB CPU and Memory is optimally used.

Lizette Koehler

How to confirm DB2 DB CPU (and Memory) is optimally used.
(in response to Deb Kumar)
On what platform?

Mainframe z/OS



*IX?



Lizette





From: Deb Kumar [mailto:[login to unmask email]
Sent: Wednesday, September 06, 2017 8:03 AM
To: [login to unmask email]
Subject: [DB2-L] - How to confirm DB2 DB CPU (and Memory) is optimally used.



How to confirm DB2 LUW DB CPU and Memory is optimally used.



Charles Brown

How to confirm DB2 DB CPU (and Memory) is optimally used.
(in response to Deb Kumar)
A very difficult question. I can tell you one thing, having worked with several DBMS products, yet i find db2 LUW memory distribution and utilization a very complex process. Let alone trying to configure LUW for optimal memory consumption. Good luck!

A very simple answer to your challenging question is -- install one database per db2 instance and configure for STMM. Why? Simply, STMM works like the fuel injection system in a car. It optimally delivers fuel into the cylinders based on workload demands. Likewise, based on workload demands, STMM will optimally distribute available memory among LUW memory consumers. LUW has plenty of them grouped into 4 pools(heaps). This makes the task a very difficult and time consuming one.

Hope this helps
Charles

Sent from my iPhone

> On Sep 6, 2017, at 10:03 AM, Deb Kumar <[login to unmask email]> wrote:
>
> How to confirm DB2 LUW DB CPU and Memory is optimally used.
>
>
> Site Links: View post online View mailing list online Start new thread via email Unsubscribe from this mailing list Manage your subscription
>
> This email has been sent to: [login to unmask email]
> Setup a data refresh task in less time than it takes to make a cup of coffee + save up to 90% in CPU
> ESAi's BCV5 & XDM fast data refresh & Test Data Mgmt products will make you a hero to users. See
> http://www.ESAIGroup.com/idug
>
> Use of this email content is governed by the terms of service at:
> http://www.idug.org/p/cm/ld/fid=2
>

Robert Wright

[AD] RE: How to confirm DB2 DB CPU (and Memory) is optimally used.
(in response to Deb Kumar)

Hi Deb

I have designed a service that will provide the answers you are looking for. There is no ongoing licence or commitment. 

Send me an email if you would like to do a Proof Of Concept - here's the documented results of a POC I recently completed.

Regards

Rob

Robert Wright
MetricsAnalysis New Zealand, Limited e: [login to unmask email] m: +64 21 726 437 w: https://www.metricsanalysis.co.nz/unique-value-proposition
Edited By:
Robert Wright[Organization Members] @ Dec 12, 2017 - 03:38 PM (Pacific/Wellington)

Michael Hannan

RE: How to confirm DB2 DB CPU (and Memory) is optimally used.
(in response to Deb Kumar)

Deb,

Maybe this is a smart-ass reply, not a very technical one, but I can confirm for you that no site has optimal DB2 CPU (and memory) usage. No site is perfectly tuned. No site has optimal SQL, Optimal table design, Optimal buffer pools, etc.

Every site can improve. Any site can be tuned. It just depends on how much money it is costing to be non-optimal. Only significant cost reductions, saving real money, matter.
 
In Reply to Deb Kumar:

How to confirm DB2 LUW DB CPU and Memory is optimally used.



Michael Hannan,
DB2 Application Performance Specialist
CPT Global Ltd