Re: Performance Issues on 570 -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

Subject: Re: Performance Issues on 570
From: Andrew Goade <agoade@xxxxxxxxxxxx>
Date: Mon, 15 Aug 2005 12:58:32 -0500
List-archive: <http://archive.midrange.com/midrange-l>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

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.

As an Amazon Associate we earn from qualifying purchases.

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.