DB2 - Determine Cost Savings in USD - After performance Tuning

Applications Programming
1

Dear Team

Have this interesting question on how to determine cost savings(USD) based on performance tuning in Db2

I am using DB2 v10.5 . I worked on db2 procedure that loaded 20Million records in just 2 Mins.
ETL execution time reduced from 30 Mins to 2 Mins.
From 15 Hrs Monthly to 1 Hr
From 180 Hrs Yearly to 12 Hrs

So how should we calculate (180-12)=168 Hrs savings in-terms of cost savings in USD.
Should we refer Cost estimate during previous/updated query or any other way .

Please guide

2

if I were your boss, i would calculate it this way.

SALARY=Perlbaby_annual_salary
let HOURLY_RATE = $SALARY / 2000
let ANNUAL_SAVINGS = (180 - 12) * $HOURLY_RATE
echo $ANNUAL_SAVINGS

Note to self: don't forget to lay off Perlbaby.

2 Likes
3

Hello @jgt . Thanks for the response . Fair answer - i wish you were my boss :slight_smile: