× 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.







Mark:

Several items need to be known first.  How many of the 100 arms are
allocated to the specific partition?  How about processor/memory?  You said
faulting was not problem, but over what period of time (use about 8 - 10
minute observations without any F5 or F10 activity in the WRKSYSSTS
command)   SQL access or native?

If you suspect that disk performance is your problem try starting a system
monitor in Management Central.  Use the average and peak for IOP and disk
units.  The graph that is produced is quite revealing.  If disk is your
problem, then you can use the ASP balance tools to balance out the usage by
usage or space.  See the information at:
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/ic2924/info/cl/straspbal.htm
.  Management Central has the ability to watch and drill down into several
performance areas that will give you some sense of what's going on.

Next check to be sure you do not have any damaged objects, particularly
access paths.  In an SQL environment the queries will continue to run,
albeit much slower without proper indexing.    You may wish to force the
access plans to change and/or rebuild the stored procedures.

That should get you started.  If you are coming to COMMON look me and the
other performance guys up at Ask the Experts, Sunday night.

Jim Oberholtzer
Senior Solutions Architect
Computech Resources, Inc.


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.