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
>