× 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 classic query engine will also throw messages into the joblog in debug mode - so your suggestion is still useful for query definitions.

Vern

Luis Rodriguez wrote:
It is very interesting how one mind's works (or not!!). When the OP wrote
about having problems with a query, I immediately jumped to the (wrong)
conclusion that problem was with a *QRYDFN object, so I suggested the STRDBG
cmd. My mistake, of course, as it is made very clear later on that the post
was about SQL.

Sigh... The age is showing up :-)

Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries


On Tue, Mar 9, 2010 at 7:08 PM, Vern Hamberg <vhamberg@xxxxxxxxxxx> wrote:

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

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

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.