Interactive Query Impacting performance

[Guest.Visitor]

Set-up AS400 720 1500 2062 supporting 200 users Problem:- Several users need to run interactive queries at various times during the day, as it produces updates direct to screen, this is obviously severly impacting the response times of other users on the system. Question:- Is there anyway of reducing the impact on CPU usage of these interactive queries by allocating them a lower priority or less CPU etc.? Any help would be greatly appreciated. Mike

[Guest.Visitor]

There are two system values (*SYSVAL) that effect all query usage. One is to optimize query to take advantage of multiple processors, and the other is to impose time limits on query processing. You might want to take a look at your current settings. Dave

[Guest.Visitor]

Mike, One option to consider would be to run: ChgJob RunPty(50) TimeSlice(5000) inside a CL program that runs these queries, then do a ChgJob to set these parameters back. You would have to have the CL adopt the appropriate authorities if the user profiles running these queries do not have *JobCtl authority. Bill

[Guest.Visitor]

In addition to that, if appropriate to their application, the CL could generate the query selection using OPNQRYF, they could use the *FIRSTIO or *MINWAIT optimization options and view the results through a subfile program one screen at a time. I'm also assuming that they've looked at indexes, views, etc.