on 11-08-2007 7:15 AM
Dear all/alaxander,
I am facing great problem with my production server. Please see it.
===========================================
System Configuration is:
AIX 5.3 /DB2/System P5 IBM Server/ 64 GB RAM but we can increase no issue.
Total Users: 200
==========================================
Buffer HitRatio % Alloc. KB Freesp. KB % Free Sp. Dir. Size FreeDirEnt % Free Dir Swaps DB Accs
Nametab (NTAB) 0
Table definition 99.94 6,797 1,386 24.32 19,990 4,861 24.32 0 46,553
Field definition 99.93 31,564 6,294 20.98 19,990 15,466 77.37 29,163 34,178
Short NTAB 99.94 3,625 2,141 71.37 4,997 2,248 44.99 0 2,749
Initial records 90.48 36,625 34,547 95.96 4,997 1,052 21.05 19,170 23,115
0
program 99.97 600,000 2,284 0.40 150,000 135,878 90.59 38,036 162,543
CUA 99.10 3,000 848 34.51 1,500 1,437 95.80 1,651,116 44,526
Screen 99.42 4,297 64 1.56 2,000 1,777 88.85 59,714 82,984
Calendar 100.00 488 359 76.22 200 49 24.50 0 151
OTR 100.00 4,096 3,375 100.00 2,000 2,000 100.00 0
0
Tables 0
Generic Key 99.35 29,297 1,068 3.85 5,000 528 10.56 12,478 5,072,562
Single record 99.72 10,000 297 3.03 500 409 81.80 1,251 97,533
0
Export/import 74.60 4,096 260 7.70 2,000 1,069 53.45 7,708,219
Exp./ Imp. SHM 98.94 4,096 3,183 94.31 2,000 1,999 99.95 0
SAP Memory Curr.Use % CurUse[KB] MaxUse[KB] In Mem[KB] OnDisk[KB] SAPCurCach HitRatio %
Roll area 0 0 131,072 0 IDs 99.28
Page area 0 0 65,536 0 Statement 98.00
Extended memory 100.00 8,376,320 8,376,320 8,376,320 0 0.00Heap memory 1,306,383 0 1,953,790 0 0.00
Call Stati HitRatio % ABAP/4 Req ABAP Fails DBTotCalls AvTime[ms] DB Rows Aff.
Select single 84.13 142,776,102 27,362,223 6,471,470 0 115,413,879
Select 80.19 199,250,652 0 22,134,490 0 171,627,222
Insert 0.00 31,728 283 32,384 0 71,660
Update 0.00 27,312 577 31,254 0 26,734
Delete 0.00 3,527 3,042 5,547 0 38,653
Total 82.16 342,089,321 27,366,125 28,675,145 0 287,178,148
====================================================
Current parameters are:
Buffer Name Comment
Profile Parameter Value Unit Comment
Program buffer PXA
abap/buffersize 600000 kB Size of program buffer
abap/pxa shared Program buffer mode
CUA buffer CUA
rsdb/cua/buffersize 3000 kB Size of CUA buffer
The number of max. buffered CUA objects is always: size / (2 kB)
Screen buffer PRES
zcsa/presentation_buffer_area 4400128 Byte Size of screen buffer
sap/bufdir_entries 2000 Max. number of buffered screens
Generic key table buffer TABL
zcsa/table_buffer_area 30000128 Byte Size of generic key table buffer
zcsa/db_max_buftab 5000 Max. number of buffered objects
Single record table buffer TABLP
rtbb/buffer_length 10000 kB Size of single record table buffer
rtbb/max_tables 500 Max. number of buffered tables
Export/import buffer EIBUF
rsdb/obj/buffersize 4096 kB Size of export/import buffer
rsdb/obj/max_objects 2000 Max. number of objects in the buffer
rsdb/obj/large_object_size 8192 Bytes Estimation for the size of the largest object
rsdb/obj/mutex_n 0 Number of mutexes in Export/Import buffer
OTR buffer OTR
rsdb/otr/buffersize_kb 4096 kB Size of OTR buffer
rsdb/otr/max_objects 2000 Max. number of objects in the buffer
rsdb/otr/mutex_n 0 Number of mutexes in OTR buffer
Exp/Imp SHM buffer ESM
rsdb/esm/buffersize_kb 4096 kB Size of exp/imp SHM buffer
rsdb/esm/max_objects 2000 Max. number of objects in the buffe
rsdb/esm/large_object_size 8192 Bytes Estimation for the size of the larg
rsdb/esm/mutex_n 0 Number of mutexes in Exp/Imp SHM bu
Table definition buffer TTAB
rsdb/ntab/entrycount 19990 Max. number of table definitions bu
The size of the TTAB is nearly 100 bytes * rsdb/ntab/entrycount
Field description buffer FTAB
rsdb/ntab/ftabsize 30002 kB Size of field description buffer
rsdb/ntab/entrycount 19990 Max. number / 2 of table descriptio
FTAB needs about 700 bytes per used entry
Initial record buffer IRBD
rsdb/ntab/irbdsize 36000 kB Size of initial record buffer
rsdb/ntab/entrycount 19990 Max. number / 2 of initial records
IRBD needs about 300 bytes per used entry
Short nametab (NTAB) SNTAB
rsdb/ntab/sntabsize 3000 kB Size of short nametab
rsdb/ntab/entrycount 19990 Max. number / 2 of entries buffered
SNTAB needs about 150 bytes per used entry
Calendar buffer CALE
zcsa/calendar_area 500000 Byte Size of calendar buffer
zcsa/calendar_ids 200 Max. number of directory entries
Roll, extended and heap memory EXTMztta/roll_area 3000320 Byte Roll area per workprocess (total)
ztta/roll_first 1024 Byte First amount of roll area used in a dialog WP
ztta/short_area 3200000 Byte Short area per workprocess
rdisp/ROLL_SHM 16384 8 kB Part of roll file in shared memory
rdisp/PG_SHM 8192 8 kB Part of paging file in shared memory
rdisp/PG_LOCAL 150 8 kB Paging buffer per workprocess
em/initial_size_MB 8184 MB Initial size of extended memory
em/blocksize_KB 4096 kB Size of one extended memory blockem/address_space_MB 4092 MB Address space reserved for ext. mem. (NT only)
ztta/roll_extension 2000683008 Byte Max. extended mem. per session (external mode)
abap/heap_area_dia 2000683008 Byte Max. heap memory for dialog workprocesses
abap/heap_area_nondia 2000683008 Byte Max. heap memory for non-dialog workprocesses
abap/heap_area_total 2000683008 Byte Max. usable heap memory
abap/heaplimit 40894464 Byte Workprocess restart limit of heap memory
abap/use_paging 0 Paging for flat tables used (1) or not (0)
Statistic parameters
rsdb/staton 1 Statistic turned on (1) or off (0)
rsdb/stattime 0 Times for statistic turned on (1) or off (0)
==============================
System Configuration is:
AIX 5.3 /DB2/System P5 IBM Server/ 8 GB RAM but we can increase no issue.
Therefore I request you to provide a solution as soon as possible. Thanking you.
With best regards
Dharmendra Kumar
Work Processor Details:
====================
0 DIA 1020158 On Hold PRIV Yes 13 SAPMF02K 300 FIPU
1 DIA 1052920 On Hold PRIV Yes 11 53 SAPMV45A 300 HYDGOD1
2 DIA 766148 On Hold PRIV Yes 9 392 /1SDBF12L/RV14AKZ1 300 SHYAM
3 DIA 897176 On Hold PRIV Yes 18 300 SAPLSMTR_NAVIGATION 300 KRPSAL1
4 DIA 925904 On Hold PRIV Yes 8 SAPLBARM 300 KRPTIM1
5 DIA 786442 On Hold PRIV Yes 4 387 SAPLS_IMG_TOOL_5 300 FIPU
6 DIA 1069206 Running Yes 8 109 ZSALESREGISTERNEW 300 BHRSAL3 Direct Read KOCLU
7 DIA 1061068 On Hold PRIV Yes 9 309 ZFI_REM_REPORT_1 300 KOLAO3
8 DIA 655426 On Hold PRIV Yes 8 287 RM_MEPO_GUI 300 CHNACC1
9 DIA 966674 On Hold PRIV Yes 6 RFITEMAR 300 CHNACC1
10 DIA 1007788 On Hold PRIV Yes 4 27 SAPLSMTR_NAVIGATION 300 BLRGOD1
11 DIA 913518 On Hold PRIV Yes 2 SAPMV60A 300 PNEACC1
12 DIA 667736 On Hold PRIV Yes 8 1 SAPDF05X 300 PNEACC1
13 DIA 717044 On Hold PRIV Yes 3 77 SAPMV60A 300 BLRGOD2
14 DIA 729272 On Hold PRIV Yes 5 335 RFITEMAP 300 DABINDER
15 DIA 860340 On Hold PRIV Yes 6 3 SAPMF05L 300 BLRACC1
16 DIA 876666 Running Yes 3 SAPLTHFB 300 DABINDER
17 DIA 843814 Running Yes 7 SAPLSLVC 300 TZTTIM1
18 DIA 815254 Waiting Yes 2
19 DIA 819348 On Hold PRIV Yes 9 ZMM_STOCK_STATUS 300 SHYAM
20 UPD 909462 Waiting Yes
21 UPD 946418 Waiting Yes
22 UPD 921636 Waiting Yes
23 BGD 1040622 Waiting Yes
24 BGD 495638 Waiting Yes
25 BGD 827544 Waiting Yes
26 BGD 1028330 Waiting Yes
27 SPO 979136 Waiting Yes 2
28 SPO 643270 Waiting Yes
29 SPO 848032 Waiting Yes
30 SPO 466944 Waiting Yes
31 UP2 647372 Waiting Yes
32 UP2 1044728 Waiting Yes
========================
Juan Reyes Writes:----
Hi Dharmendra,
In my opinion you should try reducing your ammount of DIA and SPO processes... I'll reduce DIA from 20 to 12 and SPO from 4 to 1 or 2...
Then see how the system behaves..
Regards
Juan
i think you should visit http://help.sap.com/saphelp_nw70/helpdata/en/02/96253c538111d1891b0000e8322f96/frameset.htm and configure/fine tune your memory parameters.
and Profile Parameters of Memory Management http://help.sap.com/saphelp_nw70/helpdata/en/02/96268c538111d1891b0000e8322f96/frameset.htm
cheers,
-Sunil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI
You have been mentioned that your hit ratio has been reached to 100% but you did not write the problem.
What types or problem you facing once it reach to 100% ?
When problem arising ? is it arising on peak time ?
any heavy application is running which is occupying the whole resources of application server ?
Regards
Anwer Waseem
SAP BASIS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
you have
AIX 5.3 /DB2/System P5 IBM Server/ 64 GB RAM but we can increase no issue.
and according to
SAP Memory Curr.Use % CurUseKB MaxUseKB In MemKB OnDiskKB SAPCurCach HitRatio %
Roll area 0 0 131,072 0 IDs 99.28
Page area 0 0 65,536 0 Statement 98.00
Extended memory 100.00 8,376,320 8,376,320 8,376,320 0 0.00Heap memory 1,306,383 0 1,953,790 0 0.00
you only allocate 8GB of physical memory to extended memory, you can increase the value of profile parameter related to the extended memory with bigger value.
i cant really remember what is the profile parameter, but you can go to the extended memory information row and press F1 read the technical information there.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Dharmendra,
Extended memory will be used at 100% at peak hours which is very possible. However reducing the work process is not a solution to such a case.
You need to identify the programs which are utilizing maximum amount of Extended memory using the ST03 and St02 transaction. Once you identify the programs utilizing high amount of memory, you need to check with the end users and ABAP developers, if this requirement of high memory can be reduced by splitting the program, if Y-Z cusotmer programs. If SAP program, you need to look out for SAP Notes for possible optimization of such programs.
Else you can also consider increasing the Extended memory on the server. One more thing, you should remember here. Extended memory utilization in ST02 will show the max utilization till the server restart. For e.g. check these values :
22.10.2007 15,38
21.10.2007 6,45
20.10.2007 100,00
19.10.2007 100,00
18.10.2007 100,00
17.10.2007 89,63
16.10.2007 77,51
15.10.2007 77,51
14.10.2007 17,80
This result means that there system restarted on 14 Oct, let say. Max utilization on 14 Oct was 17,80. However on 15 oct, it reached 77,51. 16 Oct shows again 77,51. It means that EM utilization on 16 Oct is either less or equal to 77,51 this day. Similarly 100% utilization shown on 18, 19 and 20 Oct means that on 18 Oct, t reached the max utlizaiton of 100% But on 19 or 20 Oct, value will still show last max threshhold reached since last restart. This max value will be released once the system is restarted as done on 21 Oct.
Hope this example makes the things simpler to you. Still if you see daily high utilization, as suggsted above, check for the programs utilizing high EM and take an action accordingly.
Hope this helps!
Award points if useful.
regards
Tanuj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.