Re: Query taking too much time on the AS/400

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.