RE: Performance Issue Questions 5.1

A good place to start on performance is the Performance Management redbook:

http://www.redbooks.ibm.com/pubs/pdfs/redbooks/sg244735.pdf

It's listed as V3R6/V3R7, but I've not found an updated version of this
book.

Authority Lookups are caused by private authorities to objects.  To tell if
your Authority lookups are causing problems check your performance
report(DSPPFRDTA) under the Excp Util column.  This shows you the portion of
total CPU utilization that is due to program exceptions.  If this is high
(>10%) exceptions are eating up you CPU and the Authority lookups are a
likely culprit.

I had a response time issue where I had tracked the RT degrading by a factor
of two over the course of a year.  I found 500,000 DLO's secured by both an
Authority List with all users on it and a group profile with all users in
it.  Changing to Public *ALL  (sorry John) at the document level, leaving
the group profile at the folder level and removing the Authorization list
dropped my Authority lookups by 80%, my Exception Utilization from over 40%
to about 10% and my RT went down about 20%.

Scott Ingvaldson
AS/400 System Administrator
GuideOne Insurance Group


-----Original Message-----
From: "Jeff Silberberg" <jsilberberg@mindspring.com>
To: <midrange-l@midrange.com>
Subject: Performance Issue Questions 5.1
Date: Thu, 10 Oct 2002 21:02:56 -0400
Organization: CompuDesigns, Inc.
Reply-To: midrange-l@midrange.com

Evening all,

        I a looking at two reports from an 830 with V5R1 on it that bother
me.

        1.) "Display TCP/IP Connection Totals" for a Display Device/User
Specifically the TCP Connection Information: Currently Open value looks
bogus. Granted this is a Webshpere 3.5 based application but the number
printed is :429,4967,275. While the Active opens: 4,265 and the Passive
OPens are 182,278, the Attempted opens that failed 5,622, and finally the
Established and then reset 8,939 values combined do not reach the Curreny
Established or even come close. Is this a bogus (PTFed) issue ??

        2.) On a Perforance "Component Report" under Exception Counts I see
"Aut Lookup" Described as "Authority Lookup: with a value of 10,527,948.
But I have not found the V5R1 document that descibes what the definition of
an Aut Lookup Exception is !!  An more important what too large a number is,
and how to address it !!

        TIA,
            JMS...
====================
Jeffrey M. Silberberg
CompuDesigns, Inc.
Atlanta, Ga. 30350-5640