RE: Performance Survey

[Chris Bipes <chris.bipes@xxxxxxxxxxxxxxx>]

Answers are in-line:

-----Original Message-----
From: Condon, Mike [mailto:M1C@xxxxxxxxxxxxxxxxx]

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 - b
2. IPL regularly (weekly?) - a
3. Keep spool files cleaned up - b (unless you are talking about thousands
of them)
4. Change QPRFADJ to 0 and manually tune system - Will effect performance
dramatically, especially if done incorrectly or there is just not enough
resources to go around.

5. Minimize the number of jobs in the system - c

There are many factors in performance tuning.  First is to Identify what
your bottle neck is?  Is it DASD access, Memory shortage, or just not enough
CPU.  Sometimes you can shorten the timeslice to stop a single job from
hogging the CPU, but if you just have too many jobs for the CPU/MEMORY/DASD
arms, there just is not much you can do except #5, reduce the work load.
One company I know of spread out the work day to 14 hours a day 6 days a
week with staggered shifts.  

Christopher K. Bipes      mailto:Chris.Bipes@xxxxxxxxxxxxxxx
Operations & Network Mgr  mailto:Chris_Bipes@xxxxxxxxx
CrossCheck, Inc.          http://www.cross-check.com
6119 State Farm Drive     Phone: 707 586-0551 x 1102
Rohnert Park CA  94928    Fax: 707 586-1884