× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: RE: Performance Question.
  • From: "DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>
  • Date: Tue, 17 Apr 2001 13:31:22 -0500

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
+---

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.