Ansicht
Dokumentation
06289 - Multiple instances on iSeries
PERFORM Short Reference CPI1466 during BackupThis documentation is copyright by SAP AG.
Multiple instances on iSeries
Hi Franco,you are having a slightly high CPU time and a catastrophal DB-time.
I guess, your disks are overloaded.
Please have a look to ST06->Detail analysis menu and then
Snapshot Analysis DISK and Previous hours DISK
There you should have a look to the Utilization and a bit more careful on
the Serv-time. I'm not sure if the last one is correct in the "previous
hours" as well. You should have times of 5 up to maximum 10ms there -
especially in ASP 2.
Then you might want to have a look to ST03 and there to the "Time Profile".
Have does the Response-time, CPU-Time and the DB-Time changes over the day,
espcially in hours with low load ?
Regards
Volker
-----Original Message-----
From: Franco Tassone [mailto:franco.tassoneZe...]
Sent: Donnerstag, 30. Mai 2002 17:26
To: DoNotReply@consolut.eu
Cc: Giampiero Bianchi; Riccardo De Luca
Subject: RE: Multiple instances on iSeries
Many thanks to all the folks who gave us their advices. We won't go on
installing multiple instances as our system is not a multi tier on and
never it will be.
We already did a tune up after our upgrade enlarging varios parameters and
buffers, but our performances are less than expected.
Our productive instance is running on an lpar of our iSeries 830, 6,5
processors (1,5 reserved for another lpar where dev and test instances
live) using about 8Gigs ram and about 350 Gigs database (on the IBM Ess).
As an example this is the workload registered yesterday, from ST03
SAP System F3C Date 29.05.2002 First record 00:00:01
Instance no. 01 Last record 23:59:59
Server S44G9031 Time elapsed 23:59:58
CPU time 71.359,5 s Database calls 22.716.903
Time elapsed 86.398,0 s Database requests 56.716.889
Direct reads 38.330.078
Dialog steps 175.700 Sequential reads 16.327.773
Changes 2.059.038
Average CPU time 406,1 ms
Av. RFC+CPIC time 15,9 ms Time per DB request 4,1 ms
Direct reads 0,7 ms
Av. response time 2.137,0 ms Sequential reads 10,1 ms
Average wait time 100,8 ms Changes and commits 18,6 ms
Average load time 51,8 ms
Av. Roll i+w time 131,2 ms Roll-in time 2.721,7 s
Av. DB req. time 1.310,9 ms Roll-out time 4.150,7 s
Av. enqueue time 0,7 ms Roll wait time 26.569,7 s
Roll-ins 253.802
Average bytes req. 152,7 kB Roll-outs 254.369
The following is the buffer and work processes configuration as show in
RZ10
ABAP programs 800000 KB Dialog 24
Nametab 45897 KB Update (V1) 5
Generic key tables 63477 KB Update (V2) 2
Single key tables 30000 KB Enqueue 1
CUA Information 10000 KB Background 6
Screens 976563 KB Spool 2
==> Initial / max. swap requirement = 11128 MB / 13036 MB
This is what's shown in the WRKSYSSTS screen:
Gestione dello stato del sistema S44G9031
30/05/02
17:20:55
% CPU in uso . . . . . . : 15,5 Memoria ausiliaria:
% capacità DB . . . . . : 9,8 ASP sistema . . . . . : 324,4
G
Tempo trascorso . . . . : 00:00:20 % ASP sistema utiliz. :
80,4780
Lavori nel sistema . . . : 2204 Totale . . . . . . . . : 359,5
G
% indirizzi permanenti . : 0,018 Att. non protetta util.: 32718
M
% indirizzi temporanei . : 0,068 Massima non protetta . : 53221
M
Immettere le modifiche (se consentite) e premere Invio.
Dim Dim
Lotto lotto riservata Max -----DB----- ---Non-DB---
sist. (M) (M) Attiv. Err. Pag. Err. Pag.
1 500,00 406,39 +++++ 0,1 0,1 12,9 54,5
2 8307,50 0,25 120 20,7 2176 116,7 180,4
3 10,00 0,00 5 0,0 0,0 0,0 0,0
4 20,00 0,00 10 0,0 0,0 2,4 4,7
Yesterday I enlarged the number of work processes because they often were
all busy. Unfortunatelly we also have a large number of "Z" programs using
too much the dialog processes I could see this in the transaction profile
of the workload analysis. With slight modifies many of them could rnu in
the background.
Unfortunatelly our PTF status is still at CUM1302510 and DB fix pack #5
(as described in APAR# II12833 02/06/02) and the kernel patch is 922. The
reason of the delay in mantaining the ptf & patches was due to system
availability reasons. A consultant of ours suggested to update the system
to the latest II12833 and to apply kernel patch 1124, because of our
performance issue
I know that non-optimized programs are an handicap for our system,
nevertheless do you think I'll see a prerformance improvements installing
the latest APAR + the latest kernel patch ?
Another question: our ESS shark uses raid-5 for the disk, so our ASP2
virtually is a raid-5, instead of a mirror: does this impact on the
performances too ?
Thanks to everybody.
Durban Tours - Südafrika Safari
PERFORM Short Reference CPI1466 during Backup
This documentation is copyright by SAP AG.
Length: 5482 Date: 20240520 Time: 155257 sap01-206 ( 4 ms )
