Re: Auto Tuning

["Ingvaldson, Scott" <SIngvaldson@xxxxxxxxxxxx>]

I would have to say that nearly every comment in this thread has (at least
some) truth to it.  As always in tuning the answer is "It depends."  No one
solution is going to work the same on every system.

My comment is before you go and blame QPFRADJ for anything, or worse, make
changes that undo its work; see what part of the whole picture you're
looking at.  On our Prod system (with our workload, yours will be different)
the total response time breaks down into 10% CPU, 10% DASD IO, 5% Faulting
and 75% Exceptional Wait.  

See Profiling an Average Interactive Transaction Using Performance Tools:
http://www-912.ibm.com/s_dir/slkbase.nsf/3cdf5d853ca698198625680b00020369/a0
70ee77bd9c23da86256d6c00699004?OpenDocument&Highlight=2,profiling,interactiv
e,transaction

In my particular case, no matter how much Memory pool tuning I do I will not
reduce my total response time more than 5%.

Don't shoot me, I'm just the piano tuner....

Regards,

Scott Ingvaldson
AS/400 System Administrator
GuideOne Insurance Group
   
This message and accompanying documents are covered by the Electronic
Communications Privacy Act, 18 U.S.C. §§ 2510-2521, and contains information
intended for the specified individual(s) only. This information is
confidential. If you are not the intended recipient or an agent responsible
for delivering it to the intended recipient, you are hereby notified that
you have received this document in error and that any review, dissemination,
copying, or the taking of any action based on the contents of this
information is strictly prohibited. If you have received this communication
in error, please notify us immediately by e-mail, and delete the original
message.