Re: Performance Question

[JOberholtzer@xxxxxxxxxxxx]

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.