high swaps in ST02

[Former Member]

Hi All,

Does anyone know what should I do if I found that my system has high buffer swaps. The hit ratio is good enough(99%).

Thanks & Regards,

Casper

[former_member197561 · Accepted solution]

Dear  Casper,

The swaps can be due to space, defined for the buffer or number of entries defined for the buffer.

You have to adjust the parameters for space and number of entries to get rid of the problem.

Best regards,

Sylvia

[Former Member]

You may need to provide more detials here...

Which buffer? ( program/nametab/export-import memory/extended memory)

[Former Member]

Hi casper,

a high Hit ratio is not ALWAYS a good thing. Is it possible that a very large table is buffered constantly in the buffer, which is accessed frequently, as a result of which, you get a high hit ratio, but there is no space left for other tables.

Please check if the ratio of Buffer Gets : User Calls if it is greater than 15..

Ifi t is, then you have some expensive select statements running and you need to tune those.

Hope this helps.

Regards

Shantanu