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

[Kirk Goins <kirkgoins@xxxxxxxxx>]

How is overall system performance? Still moving right along or has it
slowed?

On Tue, Mar 9, 2010 at 10:03 AM, dina ramzy <dina.ramzy@xxxxxxxx> 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.