|
|
Hi ,
Lot of times we notice that when no users are running any
heavy duty programs but still the system is too heavy.
On scrolling down the WRKACTJOB screen , we find
QDBSRV01 to 06 (job or substem) , and some of those are taking
major chunk of processor , for building some indexes on some file.
And I was not allowed to change the priority also.It
causes lot of problem here since on almost lot of occassion the job
started was during the most peak hours of the day.
Can anybody educate me whether
the this job(or subsystem ?) QDBSRV 01------05
starts whenever we build logical files
either by sql or by us manually ? However, we dont
face any problem when we bulid any logical files or when we run any sql
querries.
It is just few of the occassion when the system is too heavy
and there is no problem with QINTER , and when we scroll down
we see this demon eating the major chunk of the
processor.
Advise would be appreciated...
Is there any way by which we can hold or decrease the priority
... of such job...
Daj
|
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.
midrange.com
