RE: Performance Question.

Prakash,

Be careful with SETOBJACC as you might create more bottlenecks than you
solve. Unless the files are very small, you might end up using all your
storage for the files and not have any left over for your user jobs. 

What OS version are you running? Early in V4, IBM introduced the 1TB access
path that can improve DB IO for very heavily updated files. Are your
applications OPM or ILE? Optimized? What is DASD utilization (WRKDSKSTS)? Do
you have enough disk arms? Are you using database triggers? 

There are some real performance experts here on the list (not me <g>), but I
suspect you will need to give some additional information about these
programs before anyone can help.

hth,
Eric DeLong

-----Original Message-----
From: Balaji.Rao@smed.com [mailto:Balaji.Rao@smed.com]
Sent: Tuesday, April 17, 2001 12:55 PM
To: MIDRANGE-L@midrange.com
Subject: Performance Question.


Hi there,
We have a group of users who use a particular program repeatedly during the
day. This program does a lot of I/O on certain files. Since our users
started using this program the performance of the entire system has gone
down. Using DSPSYSSTS we noticed lot of DB and NON DB pages being loaded
when this program is running. We have a separate subsystem for these group
of users.
To tackle this problem we are planning to load this program and some of the
most frequently used files into memory pool attached to the subsystem using
SETOBJACC hoping to reduce the number of pages getting loaded dynamically.
Will all the jobs running in this subsystem using this program use the copy
of program and files that we loaded??? Will this work at all?????

I greatly appreciate your inputs and time to answer this.

Thank you.



Prakash Tathireddy,
SMS/SignalTree Solutions Inc,
(801) 539 4600 Xtn 2978.

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---