Swaps in ST02

[Former Member]

Hi all,

We just increased the program buffer from 850 MB to 950 MB 3 weeks back and then to 1050 MB a week back.The system looks normal for a few days and then again i can see the swpas increaing.We already have 16 GB of memory on a 64bit Win NT platform.The DB is db2 v 8.1.5......

So should i again increae it. also i read somewhere that increasing too much program buffer area willl lead to buffer fragmentation .

I am not sure . please suggest if it is ok to increase.

Also the Nametab ,Table definition, Short NTAB,Field definition, Initial records buffers are showing a lot of swaps ..

I looked at the relevant parameters:

rsdb/ntab/entrycount = 70000

rsdb/ntab/ftabsize = 62500 KB

rsdb/ntab/sntabsize = 2500 KB

rsdb/ntab/irbdsize = 30 000 KB

Which values should i change...please suggest.....

[Former Member · Accepted solution]

Hi Mangesh,

a swapping Programm buffer is normal!

But be sure that there are not more than about 10.000 Swaps a Day.

Regards

Manuel

[Former Member · Accepted solution]

Hi,

The parameters should not be changed frequently,there could be many reasons for swaps.Check your st04 and sto3n what would be the reason,if standard programs or some reports run weekly or something like that then you can not tune them and even not needed,so just check dont just change the parameters.

Regards,

Vamshi.

[Former Member]

Hi,

Yes, you are correct, increasing the sizes too much it creates adverse effect on buffer quality.

just because of some swaps you see in ST02, doesn't justify the increase the sizes.

from the Basis point of view, In a typical Prod. system we can't avoid some swaps with program buffer, but it also depend upon how many?

Things you need to keep an eye on it is, when you increase the buffer sizes, how is your buffer quality is 100% or less.. 100% is not good, typically it should be around 97-99%.

And also keep track of transport imports happening in the system, more the changes in the repository, swaps will be more (program buffer).. etc..

-K

[Former Member]

Hi Kalyan and Juan,

thanks.. for replying...

The program buffer is showing about 18000 swaps...

also the

Field definition buffer shows 151,000 buffer swaps,

Short NTAB = 19,418 buffer swaps and

initial records buffer = 54,158 buffer swaps.

We just increased the program buffer from 850 MB to 950 MB 3 weeks back and then to 1050 MB a week back.The system looks normal for a few days and then again i can see the swpas increaing.We already have 16 GB of memory on a 64bit Win NT platform.The DB is db2 v 8.1.5......

Should there be something that has to be changed in the DB2 side, or should i again increae it. also i read somewhere that increasing too much program buffer area willl lead to buffer fragmentation .

I am not sure . please suggest if and to what extent i can increase....

Also the Nametab ,Table definition, Short NTAB,Field definition, Initial records buffers are showing a lot of swaps ..

I looked at the relevant parameters:

rsdb/ntab/entrycount = 70000

rsdb/ntab/ftabsize = 62500 KB

rsdb/ntab/sntabsize = 2500 KB

rsdb/ntab/irbdsize = 30 000 KB

[Former Member]

Hi Desai,

Swaps occur there is no problem, and as far as i know there is no standard value that can be set if this many no of swaps occur.You just check and tune by using st04 detailed analysis which one is leading to longer time and then tune your buffers accordingly.Dont just keep on changing the buffer size.

Regards,

Vamshi.

[JPReyes]

Hi Mangesh,

Swaps are not directly related to the value of parameter abap/buffersize only. You have a set of memory management parameters that help you tweak the system in order to reduce as much as possible the swaping...

Read

http://help.sap.com/saphelp_nw04/helpdata/en/02/96268c538111d1891b0000e8322f96/frameset.htm

Regards

Juan