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



<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



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.