Hi guys
We currently support a client which is having serious performance issues with one application. As the application is 3rd party I'd prefer not to name them, but to me, it seems the client only has had an issue since introducing a newer version. I'll try and give as much information as I can here but unfortunately I'm a little out of my depth in understanding if there are issues with the application, the AS400 or both?
Point 1
====
It is taking somewhere between 20-30 seconds for a single screen to return. I'd say this is a serious problem with the iseries but all other applications running on it are running very well.
Point 2
=====
The client has anywhere from 20-60 users interactively.
Point 3
=====
Here is a screenshot of WRKSYSSTS for the pools
% CPU used . . . . . . . : 36.3 Auxiliary storage:
% DB capability . . . . : 21.1 System ASP . . . . . . : 111.6 G
Elapsed time . . . . . . : 01:12:14 % system ASP used . . : 81.5845
Jobs in system . . . . . : 11410 Total . . . . . . . . : 111.6 G
% perm addresses . . . . : .028 Current unprotect used : 2731 M
% temp addresses . . . . : .323 Maximum unprotect . . : 2810 M
Type changes (if allowed), press Enter.
System Pool Reserved Max Paging
Pool Size (M) Size (M) Active Option
1 143.49 78.40 +++++ *FIXED
2 738.30 1.07 91 *FIXED
3 45.33 .00 6 *FIXED
4 531.01 <.01 34 *FIXED
5 507.64 .01 6 *CALC
-and-
System Pool Reserved Max
Pool Size (M) Size (M) Active Pool Subsystem Library
1 147.55 78.41 +++++ *MACHINE
2 993.87 .95 91 *BASE
3 78.91 .00 6 *SPOOL
4 365.55 .13 34 *INTERACT
5 340.50 .10 6 *SHRPOOL1
6 20.16 .00 6 *SHRPOOL3
7 69.47 .00 7 *SHRPOOL2
Point 4
=====
When the user runs this job (interactively) I notice that the number of Non-DB faults jumpncrease to 11-13. I'm not sure if this is a high number. There was no wait-inel or active-inel threads at the same time.
System Pool Reserved Max -----DB----- ---Non-DB---
Pool Size (M) Size (M) Active Fault Pages Fault Pages
1 143.49 78.40 +++++ .0 .0 2.6 3.1
2 738.30 1.07 91 .5 21.0 3.1 9.9
3 45.33 .00 6 .0 .0 .2 .5
4 531.01 <.01 34 5.3 43.6 2.8 6.3
5 507.64 .01 6 2.4 32.9 1.6 2.6
Point 5
====
The subsystem is called LANSA. It runs in Pool 2 (*BASE).
Possible answers?
============
Should I change to *CALC for Pool2?
I noticed on WRKACTJOB that the actual job (I think it is using the Apache server) for this job that the AUXIO was 31. I'm not sure if this means anything but only seems to be a coincidence is high for the same user.
--------Elapsed---------
Opt Subsystem/Job Type Pool Pty CPU Int Rsp AuxIO CPU %
LANSA SBS 2 0 .1 0 .0
LWEB_JOB BCH 2 19 3.6 8 .0
LWEB_JOB BCH 2 19 12.4 0 .0
LWEB_JOB BCH 2 19 7.4 0 .0
LWEB_JOB BCH 2 19 4.4 31 .0
LWEB_JOB BCH 2 19 2.9 35 .0
LWEB_JOB BCH 2 19 2.5 0 .0
LWEB_JOB BCH 2 19 .6 0 .0
LWEB_JOB BCH 2 19 5.0 0 .0
As I said, it is a 3rd party application, so I can't give you details on too much there. I'd just like to confirm with our client that the AS400 is running ok, or not, as the case may be. Apparently the client's internal IT have sat on this for 12 months so now it has got to an urgent status - which is where we come in. I'm giving max points to get an answer because it is difficult and urgent in a sense.
Thanks
