Re: Performance Issues on 570

[Andrew Goade <agoade@xxxxxxxxxxxx>]

This was v5r3 related.

Andrew Goade
Hub Group Inc.
3050 Highland Parkway, Suite 100 
Downers Grove, IL 60515 
Email:  agoade@xxxxxxxxxxxx
Office: (630)795-2352
Fax:     (630)271-3647



"Dave Snyder" <dsnyder@xxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
08/15/2005 12:49 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
<midrange-l@xxxxxxxxxxxx>
cc

Subject
Re: Performance Issues on 570






Was this v5r3 related or hardware (570)?

Dave

>>> agoade@xxxxxxxxxxxx 8/15/05 1:11:19 PM >>>
Nelson,
When migrating to our 570, we noticed a big difference in programs that

used open query files.  The programs were not choosing the same 
index/access path as on v5r2.  Unfortunately, IBM in all of their
wisdom 
does not capture index builds for open query files in the database 
monitor.  So we had to put our jobs in debug to find an access path 
suggestion.  Once we built the access path, one job when from 1 hour 22

minutes to 22 seconds.