RE: Performance Survey

["Reeve Fritchman" <reeve@xxxxxxxxxx>]

1=e; it depends upon lots of factors
2=b; depends upon 5
3=b; depends upon 5
4=c; in spite of the hogwash from the autotuner vendors.  It's not that
hard...
5=b; it depends upon how many users you have and if you mean "jobs"
(regardless of status) or "active jobs"

-rf

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
> Condon, Mike
> Sent: Wednesday, February 19, 2003 2:03 PM
> To: 'Midrange Systems Technical Discussion'
> Subject: Performance Survey
> 
> I asking you all for your opinions on how the following affect
performance,
> overall and particularly interactive.
> 
> Respond with:
>  a. Will make no difference
>  b. Will make negligible difference
>  c. Will increase performance noticeably
>  d. Will increase performance dramatically
> 
> 
> 1. Disallow queries from being run in batch
> 2. IPL regularly (weekly?)
> 3. Keep spool files cleaned up
> 4. Change QPRFADJ to 0 and manually tune system
> 5. Minimize the number of jobs in the system
> 
> 
> Thanks in advance.
> _______________________________________________
> 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.