× 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.



The best tool for finding out what SQL is doing is Visual Explain in iSeries Access. Depending on your version of iSeries, you might have last SQL statements for jobs. Those can be analyzed. Otherwise, you can start a monitor in Access and collect the data for analysis.

The job log with debug turned on is good but not as much information. Still, a very good start.

HTH
Vern

dina ramzy wrote:
Dear All,

We have a query that suddenly starts today to take too much time when running on AS/400. It was taking a less than 1 minute but today it took around 3 hours!!

The files in the query have not been changed or increased too much in size.

When we run the same SQL on a Oracle database, it took a few seconds (Part of database tables on the AS/400 is being sent daily to an equivalent ones on oracle database).


Could you please advise me how to investigate what is the problem on the AS/400 side...and how to enhance the performance.

Many thanks for your help,

Best regards

Dina



_________________________________________________________________
Your E-mail and More On-the-Go. Get Windows Live Hotmail Free.
https://signup.live.com/signup.aspx?id=60969

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.