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


  1.  Home
  2. MIDRANGE-L
  3. February 2009

Re: finding sql request from download

Jim,

The simplest way to find out is to ask that certain user what big download
he uses.

I think it is is the "get data from as/400"-option in Client Access, so the
definition may be stored local on his workstation/PC.

Apparently he has made a query in Client Access without knowing the
performance hog he has created or with a little knowledge of SQL.

With regards,
Carel Teijgeler.

*********** REPLY SEPARATOR ***********

On 19-2-2009 at 17:24 JDHorn@xxxxxxxxxxxxxx wrote:

We have a user who puts in a big download to excel from iseries access and
then goes home for the night. It uses -all- the available cycles. Is
there a way to find the sql statement being processed somewhere in the
i? Is there an easy way to lower the priority of the qzdasonit jobs he
creates without lowering the priority of the other work he does during
the day?



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.