Re: Query using (too) much CPU

[Al Mac <macwheel99@xxxxxxxxxxx>]

Can these tasks go on JOBQ?
Can they be given a lower priority than other tasks?
Can they go into their own sub-system which sets aside what resources they 
are to use up?

We use more than one JOBQ, with one reserved for long running 
jobs.  Managing which end up on which JOBQ is a pain in the rear end.

> 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
>
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.