|
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 89Email : 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 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.