How To Fix HH045 - Qualité d'écriture mémoire tampon BD améliorable (mémoires tampon ?)

SAP Error Message - Details

• Message type: E = Error

• Message class: HH - (Long) text for check tool 'infcfgcheck'

• Message number: 045

• Message text: Qualité d'écriture mémoire tampon BD améliorable (mémoires tampon ?)

Quelle est la cause de ce problème?

This is a single 'performance' check and therefore does not
describe a critical system status. It is neither necessary nor
time-critical to perform the steps described below, but they could
help improve the overall performance of your R/3 System.

Le système émet un message d'erreur et ne vous permettra pas de poursuivre cette transaction tant que l'erreur n'est pas résolue.

The 'hit rate' of pages in the database buffer in percent is not
optimal for write accesses. A rate of at least 82% is considered to be
optimal. A better 'hit rate' can often be obtained by extending
the database buffer (thus reducing the 'displacement rate' of pages in
the buffer). On the other hand, the ONCONFIG parameter 'BUFFERS' should
not be increased if this is not necessary in order to keep the
use of Shared Memory (i.e. main memory) within reason.

Réponse du système

Comment corriger cette erreur?

Check the write quality of the database buffer regularly with
'onstat -p'. If the percent value is constantly below 82%, try
increasing the ONCONFIG paramter 'BUFFERS'. You can assume 20% of the
physical memory as a approximate value for the buffer size.
As user 'informix', edit file
'$INFORMIXDIR/etc/$ONCONFIG' ('BUFFERS' = number of pages).
CAUTION: The change will only become active when the database has
been started up.
Please also refer to Note 38307.

Extrait du message d'erreur du système SAP. Copyright SAP SE.