Perfomance Tuning - Cost savings

srebba · New User Joined: 26 Apr 2007 Posts: 37 Location: USA

Hi,

Before i post i searched but i could not get.. Please help me.

In my shop/application,

we want to do cost savings/cost avaoidance/application tuning/perfomance tuning.

we dont have DB2. we have VSAM as data base

we have done so far

1) for the back up VSAM file to flat file - IDCAMS replaced with SORT for huge number of records processed. saved cost.

2) Removed unwanted/processing date in batch.

3) stop generating few report which are no longer needed,

Thats it..
i wanted to more but i am not sure how can i achive.
example : High number of online transactions - i am not sure what to do.

any other more scenarios.. please help me..

Thank you,
Sree

Akatsukami · Posted: Tue Jul 24, 2012 7:15 pm

How long is a piece of string? You will not get any meaningful help on this by posting on the Internet; your managers need to turn loose of some real money and bring in consultants for hands-on analysis.

Robert Sample · Posted: Tue Jul 24, 2012 7:43 pm

"Cost savings" only applies if the site has some form of chargeback system in place. Otherwise, sites like mine that don't do chargeback have the fixed cost of the system, whether the system is 1% utilized or 100% utilized.

You may not be able to reduce the number of online transactions since that number will be a function of the work being performed and the coding of the applications being executed.

Do the standard things -- look for string waits in CICS and add strings if needed, make sure there's plenty of buffers both online and for batch access, investigate BLSR if your batch programs do a lot of random reads.

enrico-sorichetti · Posted: Tue Jul 24, 2012 7:43 pm

Ed Goodman · Active Member Joined: 08 Jun 2011 Posts: 556 Location: USA

First step is always to figure out exactly what you want to reduce. Is it CPU usage, is it Tapes allocation, is it i/o counts, is it wall clock time?

Once you have that answer in hand, the rest can fall into place quickly. For example, you decide you want to reduce i/o. This means you can add buffering to your VSAM/QSAM jobs and get big reductions in i/o. The CPU time may go up a bit, but the cost offset of the i/o could possibly be greater.

Something like "high transaction count" is abstract. Are you getting charged by the transaction? If not, then why does anyone care about the count?

I've seen people, smart people, go down all the wrong rabbit holes when it comes to performance. The biggest mistake I see is the lack of before and after testing. Because I actually use my real name, I can't tell you too many details, but I can say that spending six months changing a few IMS calls to be path calls will NOT save you hours of wall clock time. However, spending a week finding out which programs are on the critical path, then using STROBE to see what they are doing, then removing the one IMS call that doesn't really need to be there CAN save you four hours a day.

dbzTHEdinosauer · Posted: Tue Jul 24, 2012 8:13 pm

i knew that this thread would be one of those down-the-toilet discussions as soon as i read: