RE: V4R5 Performance Problem

I have a customer with this exact problem.  IBM has created an APAR for the
problem.
The APAR is MA22597.

They were able to turn off the specific E3 function and things got better.

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.


Bryan Dietz




                                                                                
                     
                    "Mark A. Manske"                                            
                     
                    <mmanske@minter-wei        To:     
<MIDRANGE-L@midrange.com>                     
                    sman.com>                  cc:                              
                     
                    Sent by:                   Subject:     RE: V4R5 
Performance Problem             
                    owner-midrange-l@mi                                         
                     
                    drange.com                                                  
                     
                                                                                
                     
                                                                                
                     
                    10/18/00 09:50 AM                                           
                     
                    Please respond to                                           
                     
                    MIDRANGE-L                                                  
                     
                                                                                
                     
                                                                                
                     




We have not upgraded, but have been "warned" by our purchasing software
vendor (E3) that some people have
had performance degradations after upgrading to V4R5 with their software.
A nightly run was taking 4-5 times longer then before the upgrade.
The letter did not mention model numbers, but we are on a 620.
Seeing how the software runs (they do not send any source code), my guess
is
that data base access has been slowed somehow; their software is not the
quickest or the leanest that I have seen with it being common to having
20-25 files open for a simple purchase order run, and ridiculous file I/O
numbers.

We at least here are waiting for another month or two before upgrading from
V4R4 to V4R5.


Mark A. Manske
[mailto:mmanske@minter-weisman.com]
Sr. Project Lead
Minter-Weisman

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---



+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---