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
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
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
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
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
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
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
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
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
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
LEARN ABOUT DEBIAN
gnc-fq-helper
GNC-FQ-HELPER(1) User Contributed Perl Documentation GNC-FQ-HELPER(1)
NAME
gnc-fq-helper - allows gnucash to communicate with Finance::Quote
over pipes from guile. The requests and responses
are scheme forms.
SYNOPSIS
gnc-fq-helper
DESCRIPTION
Input: (on standard input - one entry per line and one line per entry, and double quotes must only be delimiters, not string content --
remember, we don't have a real scheme parser on the perl side :>).
(<method-name> symbol symbol symbol ...)
where <method-name> indicates the desired Finance::Quote method. The currently recognized subset is yahoo, yahoo_europe, fidelity_direct,
troweprice_direct, vanguard, asx, tiaacref, and currency.
For currency quotes, the symbols alternate between the 'from' and 'to' currencies.
For example:
(yahoo "IBM" "LNUX") (fidelity_direct "FBIOX" "FSELX") (currency "USD" "AUD")
Output (on standard output, one output form per input line):
Schemified version of gnc-fq's output, basically an alist of alists, as in the example below. Right now, only the fields that this script
knows about (and knows how to convert to scheme) are returned, so the conversion function will have to be updated whenever Finance::Quote
changes. Currently you'll get symbol, gnc:time-no-zone, and currency, and either last, nav, or price. Fields with gnc: prefixes are
non-Finance::Quote fields. gnc:time-no-zone is returned as a string of the form "YYYY-MM-DD HH:MM:SS", basically the unmolested (and
underspecified) output of the quote source. It's up to you to know what it's proper timezone really is. i.e. if you know the time was in
America/Chicago, you'll need to convert it to that.
For example:
$ echo '(yahoo "CSCO" "JDSU" "^IXIC")' | ./gnc-fq-helper
(("CSCO" (symbol . "CSCO")
(gnc:time-no-zone . "2001-03-13 19:27:00")
(last . 20.375)
(currency . "USD"))
("JDSU" (symbol . "JDSU")
(gnc:time-no-zone . "2001-03-13 19:27:00")
(last . 23.5625)
(currency . "USD"))
("^IXIC" (symbol . ^IXIC)
(gnc:time-no-zone . 2002-12-04 17:16:00)
(last . 1430.35)
(currency . failed-conversion)))
On error, the overall result may be #f, or on individual errors, the list sub-item for a given symbol may be #f, like this:
$ echo '(yahoo "CSCO" "JDSU")' | ./gnc-fq-helper
(#f
("JDSU" (symbol . "JDSU")
(gnc:time-no-zone . "2001-03-13 19:27:00")
(last . 23.5625)
(currency . "USD")))
further, errors may be stored with each quote as indicated in Finance::Quote, and whenever the conversion to scheme data fails, the field
will have the value 'failed-conversion, and accordingly this symbol will never be a legitimate conversion.
Exit status
0 - success non-zero - failure
perl v5.14.2 2013-01-03 GNC-FQ-HELPER(1)