Re: Query using (too) much CPU

Johan,

Check system value QQRYDEGREE - set it to *NONE.

Trevor

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