DB2/LUW to DB2/ZOS Cost Analysis

Tony Moore

DB2/LUW to DB2/ZOS Cost Analysis
Hi Listers,
I currently support a DB2/LUW V11 database, running on a Unix VM machine,
under RHEL 7.7.
I've been tasked with determining the cost difference between storing our
data in LUW, versus ZOS.
Our application would continue running in the distributed environment, but
would be connecting to DB2/ZOS, instead of DB2/LUW. So I'm specifically
looking for costs for the DBMS only.

So, in short, I'm looking to find out how to capture utilization stats from
the Unix server running LUW, and convert that into a (ballpark estimate) of
mips under ZOS.

Can anyone suggest any websites, articles, etc., for this type of capacity
planning?

Thanks!
--
Tony Moore
DB2/ZOS DBA, pretending to be a DB2/LUW DBA

Jørn Thyssen

RE: DB2/LUW to DB2/ZOS Cost Analysis
(in response to Tony Moore)

Hi Tony,

To my knowledge IBM has never published such translations.

I did attend an IDUG EMEA presentation a few years back for a conversion going the opposite way. They needed a MASSIVE IBM Power machine to run the workload that required very little capacity on the z/OS side. Unfortunately I cannot recall any details beyond that :)

However, I am pretty sure if you ask the LUW crowd they will say that LUW is cheaper and if you ask the z/OS crowd they will say z/OS is cheaper.

In your specific case the workload would be offloaded 60% to zIIP assuming you have sufficient capacity.

If you already have Db2 for z/OS workload and this is your only remaining Db2 LUW server, you'll probably also realize some additional savings when you don't have to manage any LUW servers.

In Reply to Tony Moore:

Hi Listers,
I currently support a DB2/LUW V11 database, running on a Unix VM machine,
under RHEL 7.7.
I've been tasked with determining the cost difference between storing our
data in LUW, versus ZOS.
Our application would continue running in the distributed environment, but
would be connecting to DB2/ZOS, instead of DB2/LUW. So I'm specifically
looking for costs for the DBMS only.

So, in short, I'm looking to find out how to capture utilization stats from
the Unix server running LUW, and convert that into a (ballpark estimate) of
mips under ZOS.

Can anyone suggest any websites, articles, etc., for this type of capacity
planning?

Thanks!
--
Tony Moore
DB2/ZOS DBA, pretending to be a DB2/LUW DBA


 

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

2020 IBM Champion.

Views are personal. 

Edited By:
Jørn Thyssen[Organization Members] @ Jul 03, 2020 - 06:14 PM (Europe/Copenhagen)

Philip Gunning

DB2/LUW to DB2/ZOS Cost Analysis
(in response to Jørn Thyssen)
In the past when moving a workload from z/OS to Db2 LUW I’ve used a combination application transactions per sec and IO requirements to size Db2 LUW servers. Since you are looking at going the other way to z/OS you should determine your transaction per second rate and IO rate on the Db2 LUW server and then use that to determine your z/OS impact…. db2pd – osinfo can provide you with current CPU info and memory being used on the LUW server. You should then be able to then say we have a workload of x TPS and x IO requirements and work with the z/OS folks to determine impact to you z/OS Db2 subsystem. HTH Phil



IBM Champion

IBM Gold Consultant





Certified Information Systems Security Professional(CISSP)

Certification Number 539059

BS Comp Sci, MBA

Certified Advanced Db2 DBA v10.5

Certified Database Adminstrator, Db2 11.1

IBM Db2 LUW Support Page -- Db2 Support Portal https://www.ibm.com/mysupport/s/topic/0TO500000001fUNGAY/db2-linux-unix-and-windows?language=en_US&productId=01t50000004WmTk%20

Db2 Analytics Page https://www.ibm.com/analytics/data-management

Skype: DB2LUW

Twitter: DB2LUW

Direct +1.610.451.5801

IDUG DB2-L Hall of Fame

www.philipkgunning.com http://www.philipkgunning.com/AskMrDB2

IBM Business Partner

Microsoft Business Partner



From: Jørn Thyssen <[login to unmask email]>
Sent: Friday, July 03, 2020 12:14 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2/LUW to DB2/ZOS Cost Analysis



Hi Tony,

To my knowledge IBM has never published such translations.

I did attend an IDUG EMEA presentation a few years back for a conversion going the opposite way. They needed a MASSIVE IBM Power machine to run the workload that required very little capacity on the z/OS side. Unfortunately I cannot recall any details beyond that :)

However, I am pretty if you ask the LUW crowd they will say that LUW is cheaper and if you ask the z/OS crowd they will say z/OS is cheaper.

In your specific case the workload would be offloaded 60% to zIIP assuming you have sufficient capacity.

If you already have Db2 for z/OS workload and this is your only remaining Db2 LUW server, you'll probably also realize some additional savings when you don't have to manage any LUW servers.

In Reply to Tony Moore:

Hi Listers,
I currently support a DB2/LUW V11 database, running on a Unix VM machine,
under RHEL 7.7.
I've been tasked with determining the cost difference between storing our
data in LUW, versus ZOS.
Our application would continue running in the distributed environment, but
would be connecting to DB2/ZOS, instead of DB2/LUW. So I'm specifically
looking for costs for the DBMS only.

So, in short, I'm looking to find out how to capture utilization stats from
the Unix server running LUW, and convert that into a (ballpark estimate) of
mips under ZOS.

Can anyone suggest any websites, articles, etc., for this type of capacity
planning?

Thanks!
--
Tony Moore
DB2/ZOS DBA, pretending to be a DB2/LUW DBA





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] <mailto:[login to unmask email]> • W: www.rocketsoftware.com http://www.rocketsoftware.com

2020 IBM Champion.

Views are personal.



-----End Original Message-----

Attachments

  • image011.png (18.4k)
  • image012.png (12.7k)
  • image013.png (17.9k)
  • image014.png (17.7k)
  • image015.png (3.3k)

Philip Gunning

DB2/LUW to DB2/ZOS Cost Analysis
(in response to Philip Gunning)
Also you can possibly use this to determine your current MIPS of your current Db2 LUW server and provide that info the to z/OS folks…..https://www.techwalla.com/articles/how-to-calculate-mips



IBM Champion

IBM Gold Consultant





Certified Information Systems Security Professional(CISSP)

Certification Number 539059

BS Comp Sci, MBA

Certified Advanced Db2 DBA v10.5

Certified Database Adminstrator, Db2 11.1

IBM Db2 LUW Support Page -- Db2 Support Portal https://www.ibm.com/mysupport/s/topic/0TO500000001fUNGAY/db2-linux-unix-and-windows?language=en_US&productId=01t50000004WmTk%20

Db2 Analytics Page https://www.ibm.com/analytics/data-management

Skype: DB2LUW

Twitter: DB2LUW

Direct +1.610.451.5801

IDUG DB2-L Hall of Fame

www.philipkgunning.com http://www.philipkgunning.com/AskMrDB2

IBM Business Partner

Microsoft Business Partner



From: Phil Gunning <[login to unmask email]>
Sent: Saturday, July 04, 2020 11:25 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2/LUW to DB2/ZOS Cost Analysis



In the past when moving a workload from z/OS to Db2 LUW I’ve used a combination application transactions per sec and IO requirements to size Db2 LUW servers. Since you are looking at going the other way to z/OS you should determine your transaction per second rate and IO rate on the Db2 LUW server and then use that to determine your z/OS impact…. db2pd – osinfo can provide you with current CPU info and memory being used on the LUW server. You should then be able to then say we have a workload of x TPS and x IO requirements and work with the z/OS folks to determine impact to you z/OS Db2 subsystem. HTH Phil



IBM Champion

IBM Gold Consultant





Certified Information Systems Security Professional(CISSP)

Certification Number 539059

BS Comp Sci, MBA

Certified Advanced Db2 DBA v10.5

Certified Database Adminstrator, Db2 11.1

IBM Db2 LUW Support Page -- Db2 Support Portal https://www.ibm.com/mysupport/s/topic/0TO500000001fUNGAY/db2-linux-unix-and-windows?language=en_US&productId=01t50000004WmTk%20

Db2 Analytics Page https://www.ibm.com/analytics/data-management

Skype: DB2LUW

Twitter: DB2LUW

Direct +1.610.451.5801

IDUG DB2-L Hall of Fame

www.philipkgunning.com http://www.philipkgunning.com/AskMrDB2

IBM Business Partner

Microsoft Business Partner



From: Jørn Thyssen <[login to unmask email]>
Sent: Friday, July 03, 2020 12:14 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2/LUW to DB2/ZOS Cost Analysis



Hi Tony,

To my knowledge IBM has never published such translations.

I did attend an IDUG EMEA presentation a few years back for a conversion going the opposite way. They needed a MASSIVE IBM Power machine to run the workload that required very little capacity on the z/OS side. Unfortunately I cannot recall any details beyond that :)

However, I am pretty if you ask the LUW crowd they will say that LUW is cheaper and if you ask the z/OS crowd they will say z/OS is cheaper.

In your specific case the workload would be offloaded 60% to zIIP assuming you have sufficient capacity.

If you already have Db2 for z/OS workload and this is your only remaining Db2 LUW server, you'll probably also realize some additional savings when you don't have to manage any LUW servers.

In Reply to Tony Moore:

Hi Listers,
I currently support a DB2/LUW V11 database, running on a Unix VM machine,
under RHEL 7.7.
I've been tasked with determining the cost difference between storing our
data in LUW, versus ZOS.
Our application would continue running in the distributed environment, but
would be connecting to DB2/ZOS, instead of DB2/LUW. So I'm specifically
looking for costs for the DBMS only.

So, in short, I'm looking to find out how to capture utilization stats from
the Unix server running LUW, and convert that into a (ballpark estimate) of
mips under ZOS.

Can anyone suggest any websites, articles, etc., for this type of capacity
planning?

Thanks!
--
Tony Moore
DB2/ZOS DBA, pretending to be a DB2/LUW DBA





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] <mailto:[login to unmask email]> • W: www.rocketsoftware.com http://www.rocketsoftware.com

2020 IBM Champion.

Views are personal.



-----End Original Message-----



-----End Original Message-----

Attachments

  • image001.png (18.4k)
  • image002.png (12.7k)
  • image003.png (17.9k)
  • image004.png (17.7k)
  • image005.png (3.3k)
  • image006.png (4.1k)

Aurora Emanuela Dellanno

RE: DB2/LUW to DB2/ZOS Cost Analysis
(in response to Tony Moore)

Hi Tony,

 

I assume we are talking about monitoring without the help of such things as Spotlight, Optim, the AppDynamics tool or equivalent?

 

here are a few links that you may find useful (manuals, presentations and articles) - there are a bunch of courses that you can get to which are very good, by the way, for example from Verhoef, Knowledge Transfer Inc., IBM and many more:

 

https://datageek.blog/wp-content/uploads/2011/03/tutorial9_db2os.pdf?9d7bd4

http://www.ebenner.com/db2dba_blog/

http://ftpmirror.your.org/pub/misc/ftp.software.ibm.com/ps/products/db2/info/vr111/pdf/en_US/perfbook.pdf

http://www.comp.hkbu.edu.hk/en/DB2/enablement/CF41-DB2v9/StudentManual_cf419stud.pdf

http://www.dbatodba.com/db2/useful-aix-commands/monitor-cpu-mem-and-i-o-usage/

http://www.praxiumgroup.com/adug-www/prev_pres/ADUG-2011-05-20-Admin%20Views.pdf

 

 

Lastly, ruban.de have a free tool - find it here:

https://ruban.de/db2luw/tools/

 

HTH.

 

Thanks.

 

Aurora

 

PS stay safe and healthy

NB black lives matter