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



Johan,

Check system value QQRYDEGREE - set it to *NONE.

Trevor

----- Original Message ----- From: "Johan Vangilbergen" <jvg@xxxxxxx>
To: "rivendell.midrange.com" <midrange-l@xxxxxxxxxxxx>
Sent: Tuesday, February 13, 2007 9:46 AM
Subject: Query using (too) much CPU


On our 810 V5R2M0, we're having some problems with queries consuming a
lot of CPU, and slowing down all other tasks.



These queries originate mainly from 2 sources :

1. Programs with embedded SQL, which produce statistics over a
specified period of time
2. An SQL-tool, running on a PC-client, which does inquiries on the
AS400 database through ODBC.



The fact now is, that when a user starts a query (which he can define
himself) the system becomes very slow and the query consumes a lot of
CPU, killing all other jobs.



My question is : is there a way to prevent these tasks from putting the
AS400 to his knees.  I still want these tasks to be executed, eventually
at a slower rate.  But the essential is that the other jobs should not
suffer under this query.



Can anyone point me in the right direction ?







Johan Vangilbergen



YUSE

Phone : +32 16 74 50 80

Fax : +32 16 74 50 89

Email : jvg@xxxxxxx <mailto:jvg@xxxxxxx> Web : WWW.Yuse.be <http://www.Yuse.be>
Address : Bondgenotenlaan 138, B-3000 Leuven, Belgium


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.