Sponsored Content
Top Forums Programming DB2 - Determine Cost Savings in USD - After performance Tuning Post 303020997 by Perlbaby on Thursday 2nd of August 2018 05:12:02 AM
Old 08-02-2018
DB2 - Determine Cost Savings in USD - After performance Tuning

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

Last edited by Perlbaby; 08-02-2018 at 07:05 AM..
 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Performance tuning.

can someone tell me a good site to go to in order to learn this. please do not recommen nay books because i dont have interest in that. if you know of any good sites with good straight forward explanation on how to split loads on machines that has excessive loading, please let me know Also,... (1 Reply)
Discussion started by: TRUEST
1 Replies

2. Filesystems, Disks and Memory

EXT3 Performance tuning

Hi all, long time ago I posted something, but now, it is needed again :( Currently, I am handling with a big NFS Server for more than 200 clients, this sever has to work with 256 NFSDs. Because of this huge amount of NFSDs, there are thousands of small write accesses down to the disk and... (3 Replies)
Discussion started by: malcom
3 Replies

3. UNIX for Dummies Questions & Answers

Performance Tuning

Hi to all, I'm interested in finding an introduction about Performance Tuning under Unix (or Linux); can somebody please point me in the right direction? Best regards (1 Reply)
Discussion started by: domyalex
1 Replies

4. Shell Programming and Scripting

Oracle-performance tuning

Sorry, This is out of scope of this group.But I require the clarification pretty urgently. My Oracle database is parallely enabled. Still,in a particular table queries do not work "parallely" always. How is this? (9 Replies)
Discussion started by: kthri
9 Replies

5. Shell Programming and Scripting

Performance Tuning

Hi All, In last one week, i have posted many questions in this portal. At last i am succeeded to make my 1st unix script. following are 2 points where my script is taking tooooo long. 1. Print the total number of records excluding header & footer. I have found that awk 'END{print NR -... (2 Replies)
Discussion started by: Amit.Sagpariya
2 Replies

6. AIX

AIX Tuning For DB2

Dear friends. can anybody suggest me what to be considered in order to achieve maximum performance of AIX on which DB2 will be installed Thanks is advance :) (1 Reply)
Discussion started by: Vit0_Corleone
1 Replies

7. Solaris

Solaris Performance tuning

Dear all, I have a Local zone , where users feel that performance is not good. Is it wise to collect the inputs from the local zone rather than taking from the global zone. And also Can I tune from Global zone , so that it will reflect in local zone. Rgds rj (2 Replies)
Discussion started by: jegaraman
2 Replies

8. Solaris

System Check Performance Tuning

Hello Forum, Well I am fairly new to this Solaris os thing. One thing I would like to check for system health and performance. I know the codes like prstat,vmstat,sar,iostat,netstat,prtdiag -v, What else does a want to be sys admin have to look for when checking a solaris box? I know... (3 Replies)
Discussion started by: br1an
3 Replies

9. AIX

IBM AIX I/O Performance Tuning

I have a IBM Power9 server coupled with a NVMe StorWize V7000 GEN3 storage, doing some benchmarks and noticing that single thread I/O (80% Read / 20% Write, common OLTP I/O profile) seems slow. ./xdisk -R0 -r80 -b 8k -M 1 -f /usr1/testing -t60 -OD -V BS Proc AIO read% IO Flag IO/s ... (8 Replies)
Discussion started by: c3rb3rus
8 Replies
POWERD(8)						    BSD System Manager's Manual 						 POWERD(8)

NAME
powerd -- system power control utility SYNOPSIS
powerd [-a mode] [-b mode] [-i percent] [-m freq] [-M freq] [-n mode] [-p ival] [-P pidfile] [-r percent] [-v] DESCRIPTION
The powerd utility monitors the system state and sets various power control options accordingly. It offers power-saving modes that can be individually selected for operation on AC power or batteries. maximum Choose the highest performance values. May be abbreviated as max. minimum Choose the lowest performance values to get the most power savings. May be abbreviated as min. adaptive Attempt to strike a balance by degrading performance when the system appears idle and increasing it when the system is busy. It offers a good balance between a small performance loss for greatly increased power savings. May be abbreviated as adp. hiadaptive Like adaptive mode, but tuned for systems where performance and interactivity are more important than power consumption. It increases frequency faster, reduces frequency less aggressively, and will maintain full frequency for longer. May be abbreviated as hadp. The default mode is adaptive for battery power and hiadaptive for the rest. powerd recognizes these runtime options: -a mode Selects the mode to use while on AC power. -b mode Selects the mode to use while on battery power. -i percent Specifies the CPU load percent level when adaptive mode should begin to degrade performance to save power. The default is 50% or lower. -m freq Specifies the minimum frequency to throttle down to. -M freq Specifies the maximum frequency to throttle up to. -n mode Selects the mode to use normally when the AC line state is unknown. -p ival Specifies a different polling interval (in milliseconds) for AC line state and system idle levels. The default is 250 ms. -P pidfile Specifies an alternative file in which the process ID should be stored. The default is /var/run/powerd.pid. -r percent Specifies the CPU load percent level where adaptive mode should consider the CPU running and increase performance. The default is 75% or higher. -v Verbose mode. Messages about power changes will be printed to stdout and powerd will operate in the foreground. SEE ALSO
acpi(4), apm(4), cpufreq(4) HISTORY
The powerd utility first appeared in FreeBSD 6.0. AUTHORS
Colin Percival first wrote estctrl, the utility that powerd is based on. Nate Lawson then updated it for cpufreq(4), added features, and wrote this manual page. BUGS
The powerd utility should also power down idle disks and other components besides the CPU. If powerd is used with power_profile, they may override each other. The powerd utility should probably use the devctl(4) interface instead of polling for AC line state. BSD
July 4, 2013 BSD
All times are GMT -4. The time now is 08:33 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy