How To Fix HH076 - La dernière exécution des statistiques de MAJ est déjà très ancienne

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 076

• Message text: La dernière exécution des statistiques de MAJ est déjà très ancienne

Quelle est la cause de ce problème?

The last update statistics session occurred quite a long time ago.
Determine when the last session run by analyzing the SAPDBA log table
DBSTATTINF (maximum value in field LUPDSTAT).
You have either forgotten to schedule regular update statistics
sessions (Planning Calendar in Transaction DB13 or 'cronjob'), or the
scheduled interval is too large.
Only regularly executed update statistics sessions (for all tables)
can ensure that the Informix cost-based optimizer makes the correct
decisions (index instead of 'Seq. Scan',
which index, and so on).

Réponse du système

Comment corriger cette erreur?

Call Transaction DB13 (Planning Calendar) and schedule regular complete
update statistics sessions. We recommend a weekly update statistics
(for all tables) with a threshold of '10' (default value). The sessions
should run when system activity is as low as possible (for example,
during the night on the weekend).
A threshold greater than 0% insures that all tables are not processed
(-> long update statistics runtime). Instead, the system only processes
those tables whose number of records has grown or shrunk by the
specified percentage since the last update statistics session.

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