Re: V4R5 Performance Problem

["Neil Palmer"<NeilP@xxxxxxxxxxx>]

Now this is interesting.  APAR MA22597 addresses batch performance problems after upgrading from V4R4 to V4R5:
 ERROR DESCRIPTION:
  After upgrading from R440 to R450, batch jobs are now taking
  longer. The Transition Report for the job BPE3SDLY OWNE3 098016 showed
  the E3xxxx modules in the call stack calling QDBUDR, QDBGETKY
  and QDBGETSQ. The job was consistently hitting time slice end
  and the I/O was predominantly synchronous reads in large numbers.
  A PMCO trace showed BPE3SDLY job was about 80% of the hits were
  in the lic module ExTBTable (nickname EXTBTBL)
  .FindTBTable__7TBTableFPUtQ2_7TBTable14ErrorReporting
  The program next in Hit Count order was E3TFR0. We believe that
  this is the program that is causing the exceptions being
  handled by the above lic module.
 PROBLEM CONCLUSION:
  Modified code to improve performance when hitting the LIC module ExTBTable.

They issued the following PTF's:
Release 430   : MF25313 available 00/10/18 (1000 )
Release 450   : MF25305 available 00/10/18 (1000 )
Release 440   : MF25314 available 00/10/18 (1000 )

SO, I installed the V4R4 PTF last night (presumably they found the same problem in previous releases).
My COMPLETE nightly batch processing/backup job went from 4hrs 42min to 5hrs 10min.
My SAVLIB *ALLUSR, for same # & size of libraries, went from 1hr 45 min to 2hrs 11min.
(And I checked the temporary write errors via STRSST, and they were actually higher
for the run that took the least amount of time to run).

Maybe that's how you fix a batch performance degradation between V4R4 and V4R5, issue a 
PTF to degrade the performance on V4R3 & V4R4 ?   ;-)

I'll have to look into this in more detail when I get back from COMMON.

Neil Palmer      DPS Data Processing Services Canada Ltd.
50 Acadia Avenue, Ste.102                   AS/400~~~~~
Markham, Ontario, Canada.   ____________          ___  ~     
Phone:(905) 474-4890 x303   |OOOOOOOOOO| ________  o|__||=   
Cell.:(416) 565-1682 x303   |__________|_|______|_|______)   
Fax:  (905) 474-4898         oo      oo   oo  oo   OOOo=o\   
mailto:NeilP@DPSlink.com  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 
http://www.DPSlink.com     iSeries 400  The Ultimate Business Server

Robert Perno <r_perno@wshein.com> Sent by: owner-midrange-l@midrange.com 2000/10/18 09:01 Please respond to MIDRANGE-L

To:        "Midrange list serve (E-mail)" <MIDRANGE-L@midrange.com>         cc:                 Subject:        V4R5 Performance Problem

We would like to upgrade from 4.3 to 4.5 on a Model 170 although we have
been told by an outside resource that we might want to wait until IBM has
resolved a performance problem with 4.5 on the 170.  Has anyone completed an
upgrade to 4.5 on the 170?   If so, are you experiencing a performance
problem?

TIA,
Robert D. Perno
Sr. Programmer/Analyst
William S. Hein & Co., Inc.