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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.