RE: Query using (too) much CPU

["Elvis Budimlic" <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx>]

<vendor ON>
insure/RESOURCES
http://www.centerfieldtechnology.com/tools/insureresources.asp
<vendor OFF>

Tool I mentioned above lets you do things other posters already mentioned
and more.
HTH

Elvis
Celebrating 10-Years of SQL Performance Excellence

-----Original Message-----
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