Re: CPU Percentage Flex, Lies, and Usage Measuring Tape

DAsmussen@aol.com wrote:
     < snip >

> 
> >  Is the 'expert cache' (Paging option *CALC, from F11 on WRKSYSSTS) set
> >  for the pool you are running the batch job in ?
> 
> *FIXED

*CALC would increase the CPU utilization of the job and (supposedly)
reduce the amount of disk I/O.

   < snip >

> >
> >  Never mind the CPU usage of the job, how long is the job taking to
> >  complete now vs. what it took before ?  Is it still quicker than it was?
> >  With a faster CPU on the new machine a job that may have been CPU bound
> >  could now become disk bound, and unable to eat as many of the new faster
> >  CPU cycles as it it could the slower cycles on the old system.
> >  Were there any changes made to the disk configurations ?
> 
> Actually, based upon our benchmarks from when the Production box was a 320,
> it's running much slower now.  I think that I failed to mention that this is
> an SQLRPG.  

Ahh - SQL - all bets are off !
I constantly see PTF's for query optimization.  It seems they make some
major changes with each release, then spend the next several months
issuing multiple PTF's to 'fine tune' the performance.
You may want to order the SF97320 / SF97370 'shopping list' PTF cover
letters and scan the downloaded file member for QUERY, SQL, OPTIMIZE
etc. to see if you can find PTF's that may relate.  I've found that
these type of PTF's don't necessarily appear on the next cum package -
there could be a long delay from release until that happens.

Also, check sysval QQRYDEGREE, which I believe was introduced at the
same time as QQRYTIMLMT.


-- 
... Neil Palmer                                      AS/400~~~~~      
... NxTrend Technology -Canada       ____________          ___  ~     
... Markham,  Ontario,  Canada       |OOOOOOOOOO| ________  o|__||=   
... Phone: (905) 731-9000 x238       |__________|_|______|_|______)   
... url:http://www.NxTrend.com        oo      oo   oo  oo   OOOo=o\   
... mailto:NPalmer@NxTrend.com     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *