Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Extended memory uses reaches 100% at peak load time.

Dear Ruchit/all,

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

<b>Extended memory 100.00 8,376,320 8,376,320 8,376,320 0 0.00</b>Heap 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

<b>Roll, extended and heap memory EXTM</b>ztta/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

<b>em/initial_size_MB 8184 MB Initial size of extended memory

em/blocksize_KB 4096 kB Size of one extended memory block</b>em/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

Former Member
Not what you were looking for? View more on this topic or Ask a question